Forum Discussion

Copper Contributor

Sep 23, 2022

Creating a list (not columns) of comma separated values

I have a list of words (comma separated values) and want to know how to separate these words onto separate lines in the same column e.g. in column A line 1, 2, 3, 4, etc.

excel

9 Replies

dscheikey
Bronze Contributor
Nov 01, 2022
sparkieg
If you don't need a dynamic solution, you can also use "text in columns" and transpose. See my attached video. I created my video with Excel for the web.
Text_to_column.mp41.2 MB
- sparkieg
  Copper Contributor
  Nov 01, 2022
  dscheikey
  Wow, that's fantastic! Thanks so much 🙂
Harun24HR
Bronze Contributor
Sep 23, 2022
Try =TOCOL(TEXTSPLIT(A1,","))
- sparkieg
  Copper Contributor
  Sep 23, 2022
  Harun24HR
  thanks, that looks good but I'm new to excel so have no idea how to use this formula to achieve the required result.
  - Harun24HR
    Bronze Contributor
    Sep 23, 2022
    Put a screenshot of your input data then show your desired output. Better, attach a sample file to your post or comment so that we can look what you actually want?