View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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