text to column
I was given some 7000+ lines of data. It all text. Each row has all
the data in one cell and the information is separated by a differing number of "Space-bar" entries. What i am trying to do is do a text to column, but, the data is not uniform. Is there a way to removed the numeric spaces with something i can use to separate using the "text to column" feature? |
text to column
The Text to Columns wizard has a "Treat consecutive delimiters as one" option. -- Jim Cone Portland, Oregon USA . http://www.mediafire.com/PrimitiveSoftware . (XL Companion add-in: compares, matches, counts, lists, finds, deletes...) "B~O~B" wrote in message ... I was given some 7000+ lines of data. It all text. Each row has all the data in one cell and the information is separated by a differing number of "Space-bar" entries. What i am trying to do is do a text to column, but, the data is not uniform. Is there a way to removed the numeric spaces with something i can use to separate using the "text to column" feature? |
All times are GMT +1. The time now is 06:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com