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