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”