excel transform column to list code example

Example: excel transform column to list

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"