Hi guys
I don't think I can use text to columns here...
I have cell A1 populated with words including single words, up until 2-3 words
I.e
Cell A1:
Cancelled
Still waiting
never received it
Bad
Service
How can I split all the content from A1 into A1, A2, A3 and so on?
Text to columns is not helpful for me - unless i`m selecting something wrong.
Pls advise. thank you!
Update I have the option to add commas to my data too but this is still going into ONE CELL and I want to split these across cells... all in column A
Bookmarks