Tuesday, February 16, 2016

Convert a column into a comma separated 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"



http://superuser.com/questions/240858/convert-a-column-into-a-comma-separated-list

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home