| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
| How do i execute a VBA function by clicking on an excel cell? | Excel Discussion (Misc queries) | |||
| Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
