Is there an Excel function for this?
 

Hello,
I am looking to 1; combine serveral columns into a new column and 2; add
quotes around the Last Names in all of the last name cells. An example of
what I'm trying to do below:

Last Name cell | E-mail cell | "last name", e-mail address (desired new
cell)

I need this done to multiple cells.
Please help,
Larry

Is there an Excel function for this?
 

where A1 contains the last name and B1 contains the email address

=""""&A1&""""&", "&B1

copy down.


"Larry" wrote:

Hello,
I am looking to 1; combine serveral columns into a new column and 2; add
quotes around the Last Names in all of the last name cells. An example of
what I'm trying to do below:

Last Name cell | E-mail cell | "last name", e-mail address (desired new
cell)

I need this done to multiple cells.
Please help,
Larry

Is there an Excel function for this?
 

One other thing, if you want to get rid of the original data, you will need
to hardcode your new cells.

Copy your new column, then click Edit/Paste Special - values.



"Larry" wrote:

Hello,
I am looking to 1; combine serveral columns into a new column and 2; add
quotes around the Last Names in all of the last name cells. An example of
what I'm trying to do below:

Last Name cell | E-mail cell | "last name", e-mail address (desired new
cell)

I need this done to multiple cells.
Please help,
Larry

Is there an Excel function for this?
 

A2=Lastname
B2=E-mail
in C2:

="""" & A2 & """" & ", " & B2

HTH

"Larry" wrote:

Hello,
I am looking to 1; combine serveral columns into a new column and 2; add
quotes around the Last Names in all of the last name cells. An example of
what I'm trying to do below:

Last Name cell | E-mail cell | "last name", e-mail address (desired new
cell)

I need this done to multiple cells.
Please help,
Larry