Thread
:
How do I convert last name, first name in cells to first name las.
View Single Post
#
5
David
Posts: n/a
?B?c291dGhlcm4=?= wrote
Cells contain names in last name, first name order. I wish to convert
to first name last name (no comma) without retyping. Thanks
One more way:
=IF(A1="","",RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(",",A1)-1))
--
David
Reply With Quote