Add comma in last name first name
 

Currenly, I have lastname firstname in the same cell and need to add a comma
to show lastname, firstname in the same cell. Any suggestions for a formula?
Thank you in advance.

Answer: Add comma in last name first name
 

Sure, I can help you with that! You can use the function in Excel to add a comma between the last name and first name. Here are the steps:

1. Select the cell where you have the last name and first name together.
2. In the formula bar, type
   Formula:

   ---

   =CONCATENATE(A1,", ",B1) 


   ---

   where A1 is the cell with the last name and B1 is the cell with the first name.
3. Press Enter and you will see the last name and first name separated by a comma in the same cell.

Alternatively, you can use the ampersand (&) symbol instead of the function. Here's how:

1. Select the cell where you have the last name and first name together.
2. In the formula bar, type
   Formula:

   ---

   =A1&", "&B1 


   ---

   where A1 is the cell with the last name and B1 is the cell with the first name.
3. Press Enter and you will see the last name and first name separated by a comma in the same cell.

Add comma in last name first name
 

=SUBSTITUTE(A1," ",", ")

so if A1 contains:
Ravenswood James
the formula returns:
Ravenswood, James
--
Gary''s Student - gsnu200858


"Johnnie" wrote:

Currenly, I have lastname firstname in the same cell and need to add a comma
to show lastname, firstname in the same cell. Any suggestions for a formula?
Thank you in advance.

Add comma in last name first name
 

=A1 &" , " & A2

"Johnnie" wrote:

Currenly, I have lastname firstname in the same cell and need to add a comma
to show lastname, firstname in the same cell. Any suggestions for a formula?
Thank you in advance.

Add comma in last name first name
 

ctrl+H

replace " " by ", "

the quotes are just to show the space.

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Johnnie" escreveu:

Currenly, I have lastname firstname in the same cell and need to add a comma
to show lastname, firstname in the same cell. Any suggestions for a formula?
Thank you in advance.

Add comma in last name first name
 

Of course, none of the suggestions handle the following two situations,
mainly because there is no way to handle them (except with a lookup table of
some sort)...

First Name: Mary Anne
Last Name: Jones

First Name: Robert
Last Name: Della Rossa

Name's (first or last) consisting of multiple "words" will always present a
problem and since the can be mixed together in the same list, there exists
no general solution on how to handle them. The above example uses name parts
from friends of mine; just think if they were this...

First Name: Mary Anne
Last Name: Della Rossa

--
Rick (MVP - Excel)


"Johnnie" wrote in message
...
Currenly, I have lastname firstname in the same cell and need to add a
comma
to show lastname, firstname in the same cell. Any suggestions for a
formula?
Thank you in advance.