splitting data from a cell into different cells

[jartzh]

I have a column that has data with multiple values seperated by commas. I need to seperate out the values and add them to a new column.

Example:

Column A
good, cheap, fast
slow
good
cheap
cheap,good



I would like them to be added to column B as:
good
cheap
fast
slow
good
cheap
cheap
good

[jasoncw]

See if this works for you:

Please Login or Register  to view this content.

HTH

Jason

[DonkeyOte]

An alternative based entirely upon Jason's routine but that uses Application.Transpose to return the Array in one go

Please Login or Register  to view this content.

[jasoncw]

Good one, Donkey.

[jartzh]

You guys are amazing.
This works perfectly.

Thanks

[jasoncw]

Glad it helped. Please mark the thread solved.

Jason

[jartzh]

Jasoncw,
How do I mark this as SOLVED?

[jasoncw]

If you click on the How To drop down at the top of the forum, it tells you.

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save