change lname, fname to fname last name

A

Al Wills

I have work sheet with names listed as last name, first name, I would like to
have them as just first name last name.

Suggestions??
 
J

JMB

if your data starts in cell A1:

=TRIM(RIGHT(A1,LEN(A1)-SEARCH(",",A1,1)) & " " & LEFT(A1,SEARCH(",",A1,1)-1))
 
B

Biff

Hi!

Try this:

A1 = Smith, John

=MID(A1,FIND(",",A1)+2,255)&" "&LEFT(A1,FIND(",",A1)-1)

Returns: John Smith

Biff
 
A

Al Wills

Hi JMB,

Not quite, I still get lastname, firstname lastname ~ Thanks a lot though,
the post from Biff worked fine!

Thanks a lot!

Al
 
Top