Forum Discussion
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.
Try =TOCOL(TEXTSPLIT(A1,","))
thanks, that looks good but I'm new to excel so have no idea how to use this formula to achieve the required result.
- 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?
This is the list of vocab words that I want to separate so that I have one word in each cell e.g.
A1 dingin
A2 hangat
A3 baru .... etc. I would like to know the step by step procedure for achieving this.
Many thanks...
dingin, hangat, baru, banyak, betul, sedikit, kecil, panjang, pendek, tinggi, muda, tua, jelek, cantik, bersih, kotor, miskin, jauh, dekat, jelas, rusak, bodoh, sempurna, sulit, mudah, biasa, pintar, mirip, lain, bahagia, sedih, penuh
