Thread: Txt to columns
View Single Post
  #1  
Old September 23rd, 2008, 07:56 PM posted to microsoft.public.excel.worksheet.functions
Learn Excel
external usenet poster
 
Posts: 3
Default Txt to columns

I work a lot on the database of the following format which contains just
numbers.

5555 21 38 50 55 164 | 10 5 2 200
20| 164

The first column is always 4 digit. The rest of the columns can be anything
from 0 to 1000. Can someone help me separate these texts to columns using
the functions? I do this task repeatedly on different sets of data so using
text to colums command is not much time saving either.

Thanks