View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
GARY GARY is offline
external usenet poster
 
Posts: 117
Default Importing text-files

I opened the text file as a delimited file (so Col A contains cells
1,274 characters long).

In B1 thru DD1, I wrote formulas (referring to A1) to divide the data
into separate fields (with the desired formatting).

I then copied and pasted those formulas down to the last row containing
data.

(It took some time but the results are exactly what I needed)