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
I would like to transform this text into the column A so there will be one word at a linePlease Login or Register to view this content.
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.Please Login or Register to view this content.
Thank you, any help will be appreciated.
samplefile.xlsx
Bookmarks