Excel - Find and Replace from rows to separation by commas
This is the one! This was super easy. I kept thinking that I know I can
choose characters from a list with find and replace and I had forgotten that
I can do it in Word! Thanks!
"Martin P" wrote:
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?
|