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

=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

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

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

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

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

"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