Arranging Names in a cell
 

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

Arranging Names in a cell
 

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

--

HTH

Bob Phillips

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

"Jamie G." wrote in message
...
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

Arranging Names in a cell
 

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)


"Jamie G." wrote:

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

Arranging Names in a cell
 

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

"Barb Reinhardt" wrote:

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)


"Jamie G." wrote:

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

Arranging Names in a cell
 

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...

"Barb Reinhardt" wrote:

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)


"Jamie G." wrote:

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

Arranging Names in a cell
 

See my response

--

HTH

Bob Phillips

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

"Jamie G." wrote in message
...
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...

"Barb Reinhardt" wrote:

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)


"Jamie G." wrote:

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

Arranging Names in a cell
 

"Jamie G." wrote in message
...
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?

You could try Data/ Text to Columns
then concatenate the other way round.
--
David Biddulph