Convert single column to comma separated row value

https://superuser.com/a/432755/78532 

A very useful way to convert excel column to comma separated value using word.

copy pasting here in case if the link not available.

  • Copy the column in Excel
  • Open Word
  • “Paste special” as text only
  • Select the data in Word (the one that you need to convert to text separated with ,), press Ctrl-H (Find & replace)
  • In “Find what” box type ^p
  • In “Replace with” box type ,
  • Select “Replace all”

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.