Thank you so very much! Couldn't figure out how to use this function with
the Microsoft help (kept getting circular reference) your response indicated
how to prevent that!

"Nick Hodge" wrote:

For data in A1, enter this in B1 and then copy and paste special the data
back to column A to replace it

=PROPER(A1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"HowGirl" wrote in message
...
Is there a way to format cells in Excell to automatically capitalize the
first letter of text in a cell?