Thread: text to column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
B~O~B B~O~B is offline
external usenet poster
 
Posts: 19
Default 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?