Hi guys,

I would like to ask the more experienced ones how to deal with the following problem:

In B1, I have several text strings separated by comma and blank space
apples123, oranges879, [email protected], grapes, pears879
I would like to transform this text into the column A so there will be one word at a line
apples123
oranges879
[email protected]
grapes
pears879
The original file contains about 500 word in B1 so if there is an elegant way how to achieve that, it would save me a lot of time.

Thank you, any help will be appreciated.
samplefile.xlsx