I have a string of text in Cell A1. The text is separated by spaces. Everywhere there is a space, I would like to place that text in a column. I have over 9,000 lines of data. Since I can't upload a spreadsheet, I am posting (2) pictures. One is an example, the other is what I would like the result to look like. Thanks for any and all help in advanceData.jpgResult.jpg
Enter formula in B1 and pull it to the right until you see blanks.
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
It will not let me give you any more kudos since you were last one to answer my last issue. It says I must spread the love to someone else before I can give you a high five. Just know I appreciate the help tremendously!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks