function help!

J

jkb724

Is there a way I can switch a last name, first name to first name an
last name? i.e... Smith, John to John Smith

I'd greatly appreciate some assistance
 
F

Frank Kabel

Hi
if they are always divided by a coma use the following
formula:
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND
(",",A1)-1))
 
J

Jason Morin

One way:

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND
(",",A1)-1)

HTH
Jason
Atlanta, GA
 
Top