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

How to make the shading look uniform around a double spaced line in MS Word? 0
How to center adjust text above and image in a two column document. 1
Formating bolded text exclusively. 0
Generated text copies into another template 0
MS Project Center-Autolink column fields 0
Format column widths from one table to a separate table on same page 1
Two columns followed by single page-width column on same page 0
Select Text to End of Footnote 9

Top