Fix the order of the last name and first name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi
try
=TRIM(MID(A1,FIND(",",A1)+1,255)) & " " & TRIM(LEFT(A1,FIND(",",A1)-1))
 
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".
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
newline 9
changing name order 1
VBA - retrieve data on last create named range from previous inserted named range 0
last name, first name strings 6
Separating Last Name, First Name into Two Fields 4
Extracting Last Name and First Initial 4
How do I separate first and last names into two columns? 2

Back
Top