Another one...

=PROPER(MID(A2&" "&A2,FIND(",",A2)+2,LEN(A2)-1))

--
Biff
Microsoft Excel MVP


"Erinayn" wrote in message
...
I have data in LAST, FIRST and used this formula...

=TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1)

Is there a way to change it from all caps to just capitalized names.

Ex.
currently - DOE, JOHN
change to - John Doe