| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine rows and add semicolon
I have inherited a spreadsheet with a column for e-mail addresses.
I need to combine all of the addresses to send a single e-mail to each person in the list. I have tried conctenate and copy down the column thinking it would be cumulative, but it doesn't seem to work. I think I am messing up the formula somewhere. Any help would be greatly appreciated. Here is what I had tried: =CONCATENATE(P2,"; ",P3) then I copy down the column. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I add a semicolon at the end of a name in 400 rows at once | Excel Discussion (Misc queries) | |||
| Macro to combine 'like' rows | Excel Discussion (Misc queries) | |||
| combine 2 rows into 1 record | Excel Discussion (Misc queries) | |||
| Combine rows | Excel Discussion (Misc queries) | |||
| how to combine the multiple rows into one rows? | Excel Worksheet Functions | |||
Threaded Mode
