Arranging Names in a cell

J

Jamie G.

I have a large list of people who are listed Last name first in a cell. I
want to show the names in that cell to be First Name & then Last name. How
can I accomplish this?

Thanks

Jamei
 
B

Bob Phillips

=MID(A2& " " & A2,FIND(" ",A2)+1,LEN(A2)+1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
B

Barb Reinhardt

You'll have to do this step wise.

First, parse out the first and last names into different cells (see
functions MID, LEFT and RIGHT)
Then concatenate them back together the way you want. (see CONCATENATE)
 
J

Jamie G.

If my names are all different lenghts how do I select the length??
If a comma seperates the first and last name can I use that? If so how
would i do that? Thanks again

Jamie
 
J

Jamie G.

Now that I think about it, stripping out the first name and placing it in a
different cell would also accomplish my goal. Any ideas...
 
B

Bob Phillips

See my response

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
D

David Biddulph

Jamie G. said:
I have a large list of people who are listed Last name first in a cell. I
want to show the names in that cell to be First Name & then Last name.
How
can I accomplish this?
Click to expand...

You could try Data/ Text to Columns
then concatenate the other way round.
 
Top