=LEFT(A1,1)&LOWER(MID(A1,2,FIND(" ",A1)-1))&MID(A1,FIND("
",A1)+1,1)&LOWER(RIGHT(A1,LEN(A1)-FIND(" ",A1)-1))

--
HTH

Bob Phillips

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

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