Why do we never get to find out how Co-Ca Cola is made? I mean,what's this secret formula all about,any how?*

The secret formula is just marketing hype. There's nothing special about it at all.

This is from the Wikipedia, which is sometimes accurate about certain subjects:

The exact formula of Coca-Cola is a famous trade secret. The original copy of the formula is held in SunTrust Bank's main vault in Atlanta, Georgia, USA. Its predecessor, the Trust Company, was the underwriter for the Coca-Cola Company's initial public offering in 1919. A popular myth states that only two executives have access to the formula, with each executive having only half the formula. The truth is that while Coca-Cola does have a rule restricting access to only two executives, each knows the entire formula and others, in addition to the prescribed duo, have known the formulation process.

When launched, Coca-Cola's two key ingredients were cocaine (benzoylmethyl ecgonine) and caffeine. The cocaine was derived from the coca leaf and the caffeine from kola nut, leading to the name Coca-Cola (the "K" in Kola was replaced with a "C" for marketing purposes).

Coca — Cocaine
The originator called for five ounces of coca leaf per gallon of syrup, a significant dose; in 1891, it was claimed the formula (altered extensively from Pemberton's original) contained only a tenth of this amount. Coca-Cola did once contain an estimated nine milligrams of cocaine per glass, but in 1903 it was removed. Coca-Cola still contains coca flavoring, and to this day, the FDA still tests random sample bottles or cans of the product, to make sure that the cocaine is still gone from it.

After 1904, instead of using fresh leaves, Coca-Cola started using "spent" leaves—the leftovers of the cocaine-extraction process with cocaine trace levels left over at a molecular level. To this day, Coca-Cola uses as an ingredient a cocaine-free coca leaf extract prepared at a Stepan Company plant in Maywood, New Jersey.

In the United States, Stepan Company is the only manufacturing plant authorized by the Federal Government to import and process the coca plant. Stepan laboratory in Maywood, New Jersey is the nation's only legal commercial importer of coca leaves, which it obtains mainly from Peru and, to a lesser extent, Bolivia. Besides producing the coca flavoring agent for Coca-Cola, Stepan Company extracts cocaine from the coca leaves, which it sells to Mallinckrodt, a St. Louis, Missouri pharmaceutical manufacturer that is the only company in the United States licensed to purify cocaine for medicinal use. Stepan Company buys about 100 metric tons of dried Peruvian coca leaves each year, according to Marco Castillo, spokesman for Peru's state-owned National Coca Co.

Kola Nut — Caffeine
Kola nuts act as a flavoring in Coca-Cola, but they are also the beverage's source of caffeine. In Britain, for example, the ingredient label states "Flavourings (Including Caffeine)." Kola nuts contain about 2 to 3.5 percent caffeine, are of bitter flavor and are commonly used in cola soft drinks. In 1911 The U.S. government initiated United States v. Forty Barrels and Twenty Kegs of Coca-Cola, hoping to force Coca-Cola to remove caffeine from its formula. The case was decided in favor of Coca-Cola. Subsequently, in 1912 the U.S. Pure Food and Drug Act was amended, adding caffeine to the list of "habit-forming" and "deleterious" substances which must be listed on a product's label.

Coca-Cola contains 34 mg of caffeine per 12 fluid ounces, while Diet Coke Caffeine-Free contains 0 mg. Caffeine may be used by athletes, as an ergogenic aid, to increase the capacity for mental or physical labor. The ergogenic qualities of caffeine are contested, although there is strong evidence that it may significantly enhance endurance. For this reason, caffeine is listed as a restricted substance by the International Olympic Committee (IOC). Nevertheless, Coca-Cola was the leading sponsor of the 1996 summer Olympic games.

The full article about Coca-Cola can be read here:

http://en.wikipedia.org/wiki/Coca-Cola