Excel 2003 can do this, though I'm not sure if Excel 2000 can. The formula is Proper. So if A1 says MICROSOFT CORPORATION, define B1 to be (without quotes)

"=PROPER(A1)"

You can also use the code UPPER and LOWER. PROPER means first letter in caps.