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

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

"JF" wrote in message
...
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" wrote in message
news:PuDke.16796$Fv.4842@lakeread01...
In A1 -- new york city In B1 -- =Proper(a1) displays
New York City
HTH

"JF" wrote in message
...
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



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