Hi guys
I have a txt file with mutiple words separate by commas.
The layout is in paragraph format i.e.
dealer, unsubscribe, un-subscribe, email list, reject, they took, money laundering,
I want to copy and paste this list into excel, but it is splitting up words i.e. one word per cell. I also can't use paste special until after the data is in excel
can anyone suggest how to maintain the format but put the data into a vertical list format i.e.
dealer
unsubscribe
email list
etc
etc
thank you!
Bookmarks