View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nebb
 
Posts: n/a
Default Concatenate shortcut?


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