Formatting Text

[JF]

Is there any way to make excel make every word in any cell begin with a
capital letter even if I type everything in lower case. Not just the
beginning of the sentence but every word contained in the sentence.
I'm using Office 2002

Thanks
John

 

[Jim May]

In A1 -->> new york city In B1 -->> =Proper(a1) displays
New York City
HTH

 

[JF]

In A1 -->> new york city In B1 -->> =Proper(a1) displays
New York City
HTH

That's what I am looking for, but is there a way to format the whole page
before i start typing. The sheet is basically a list of mp3's which I own
and contains only text

Thanks
John