Is there an Excel function for this?

[Larry]

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

[JMB]

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

[JMB]

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

[Toppers]

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