text to column

B

B~O~B

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split column contents (de-concantenate) 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
text to column 6
Reformatting data 3
using the =page! feature to transpose a row to column 0
Convert Number to Text for Index/Match 1
Text To Columns 2
In Cell Formula to mimic text to columns. 3

Top