Converting Text Format from LAST NAME, First Name to First Name La

  • Thread starter Thread starter Tina
  • Start date Start date
T

Tina

I have imported data from another program and all of the names are in this
format: Last Name, First Name

How can I change to First Name Last Name???
 
You can use this to swap names around:
=MID(A2,FIND(",",A2)+2,256)&" "&LEFT(A2,FIND(",",A2)-1)
Then copy, paste special-> values.
 
With
A1: The Clown, Bozo

This formula converts that text to FirstName LastName
B1: =TRIM(MID(A1&" "&A1,FIND(",",A1&" "&A1)+1,LEN(A1)))

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)
 
Actually made that formula more complicated than it needed to be.
Try this:
B1: =TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)))

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)
 

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

Changing text in a cell from last name first to first name first. 2
Reversing Last Name and First Names 2
Last Name, First Name extract 2
Converting full Names from 1 cell to 2 5
extract name 3
reformat a cell from last name, first to first space last? 5
How do I convert last name, first name in cells to first name las. 4
Grabbing the Last name 6

Back
Top