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.
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
sparkieg here is another example if you don´t have available yet the formula TOCOL
- Hi Alan, I'm wanting to do this again with numerous lists of vocab words and your formula worked well last time. Unfortunately I still don't know how to repeat it with a new list of words. I'm wondering if you can give me step by step instructions for how to do it as I am a retired person who is new to Excel. Many thanks, Mark
