View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default Concatenating an array??

jgkocis wrote...
Actually not spam.

I am wedding photographer and went to a bridal show where all brides
that wanted more information provided their email address. I received
all the email addresses in an excel sheet, but to send them from yahoo
i dumped them into a txt file, but have to manually add the "," unless
someone can suggest a way to replace the carriage return with a comma.


Try a Google Groups search for the mcat function. The MCONCAT function
in the MOREFUNC.XLL add-in won't help because it can't cope with so
many characters in the result string.