Is there an Excel function for this?

L

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
 
J

JMB

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

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

copy down.
 
J

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