LOL, forgot PROPER

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Alan" wrote in message
...
With JOE SMITH in A1 try
=PROPER(A1), drag down to the end of the list and Copy Paste Special
Values to lose the formulas,
Regards,
Alan.
"Diane Walker" wrote in message
...
I got this file that has employee names. However, the names are all in
capital letters. Is there a way to break the name in the appropriate
case?
For example, the name is JOE SMITH. I would like the name to be
displayed
as Joe Smith. Thanks.