function help!

[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

 

[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))

 

[Norman Harker]

Hi jkb724!

Probably the easiest approach is to use Data > Text to Columns.

 

[Jason Morin]

One way:

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

HTH
Jason
Atlanta, GA

 

[jkb724]

THANK YOU THANK YOU THANK YOU!