Z
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.
first name is second, separated by a comma.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
Hi!
What order do you want them in?
Biff
What order do you want them in?
Biff
F
Frank Kabel
Hi
try
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1))
try
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1))
J
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".
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".
Z
Zami
Z
Zami
I want first name then last name
Biff said:Hi!
What order do you want them in?
Biff
Z
Zami
Frank Kabel said:Hi
try
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1))
Z
Zami
Thank you I'll try that...
Frank Kabel said:Hi
try
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1))
Z
Zami
Thank you, I'll reply to let you know which one was helpful.