Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() I have a column in a worksheet containing 110 rows, each of which has a single email address. I would like to concatenate the contents of all 110 cells, each one separated from the next by a comma to be used as a single email address. Is there an easier way to do this other than to write a formula in which I have to identify each and every cell to be included in the concatenation? -- nebb ------------------------------------------------------------------------ nebb's Profile: http://www.excelforum.com/member.php...fo&userid=8981 View this thread: http://www.excelforum.com/showthread...hreadid=492425 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shortcut Keys -- quick find | Excel Discussion (Misc queries) | |||
Concatenate | Excel Discussion (Misc queries) | |||
how can you customize a shortcut menu in excel? | Excel Discussion (Misc queries) | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
How to make [toggling] shortcut keys to superscript and subscript, respectively? | Excel Discussion (Misc queries) |