Thanks so much - this will work for me.

"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?