Fix the order of the last name and first name

[Zami]

How do I fix the order of the names, when the last name is first and the
first name is second, separated by a comma.

 

[Biff]

Hi!

What order do you want them in?

Biff

 

[Frank Kabel]

Hi
try
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1))

 

[John Mansfield]

Zami,

Another formula option in addtion to Frank's . . .

=MID(TRIM(H38),FIND(" ",TRIM(H38),1)+1,LEN(TRIM(H38)))&"
"&LEFT(TRIM(H38),(FIND(",",TRIM(H38))-1))

turns "Bowman, Frank" into "Frank Bowman".

 

[Zami]

Thank you...

Hi!

What order do you want them in?

Biff

 

[Zami]

I want first name then last name

Hi!

What order do you want them in?

Biff

 

[Zami]

Hi
try
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1))

 

[Zami]

Thank you I'll try that...

Hi
try
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1))

 

[Zami]

Thank you, I'll reply to let you know which one was helpful.