Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fix the order of the last name and first name
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. |
#2
|
|||
|
|||
Hi!
What order do you want them in? Biff -----Original Message----- 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. . |
#3
|
|||
|
|||
Hi
try =TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1)) -- Regards Frank Kabel Frankfurt, Germany Zami wrote: 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. |
#4
|
|||
|
|||
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". ---- Regards, John Mansfield http://www.pdbook.com "Zami" wrote: 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. |
#5
|
|||
|
|||
Thank you...
"Biff" wrote: Hi! What order do you want them in? Biff -----Original Message----- 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. . |
#6
|
|||
|
|||
I want first name then last name
"Biff" wrote: Hi! What order do you want them in? Biff -----Original Message----- 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. . |
#7
|
|||
|
|||
Thank you I'll try that...
"Frank Kabel" wrote: Hi try =TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1)) -- Regards Frank Kabel Frankfurt, Germany Zami wrote: 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. |
#8
|
|||
|
|||
"Frank Kabel" wrote: Hi try =TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1)) -- Regards Frank Kabel Frankfurt, Germany Zami wrote: 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. |
#9
|
|||
|
|||
Thank you, I'll reply to let you know which one was helpful.
"John Mansfield" wrote: 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". ---- Regards, John Mansfield http://www.pdbook.com "Zami" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|