View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Martin P
 
Posts: n/a
Default Excel - Find and Replace from rows to separation by commas

This can also quickly be done via Word. Copy to Word, convert table to text,
and use Edit, Replace in Word to replace paragraph mark with comma. Copy to
Excel.

"msdker" wrote:

I would like to take information that is one column but over 2000 rows and
move it into the A1 cell, but separated by commas. So instead of separation
by rows, make it separation by commas. How do I do this?