modifying name format within a cell

M

Myk

I currently have a list of names all in one column of cells that are
formatted last name, first name (with a space after the comma). I need to
change to first name last name. There are several names with no space after
the comma in case that matters.

Is there an easy way to make this change?

Thanks,
MYK
 
L

Luke M

=TRIM(MID(A2,FIND(",",A2)+1,999))&" "&LEFT(A2,FIND(",",A2)-1)

This will handle both cases of having a space, or no space
 
J

Jim Thomlinson

Try a formula like this...

=TRIM(MID(A1, FIND(",", A1)+1, 256)) & " " & LEFT(A1, FIND(",", A1)-1)
 

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

reformat a cell from last name, first to first space last? 5
splitting Last Name, First Name 4
Pesky spaces 1
Space after comma 2
I want first name only 4
Help splitting text entries with commas 1
Can I switch the order of text entries in a cell? 3
Separating a name into first name and last name columns 2

Top