Importing fixed-width data

J

juliette

Dear all,

I have a large number of huge text-files I want to import in Excel. Th
data are in fixed-width format (each value is 5 characters long), bu
there's no space or separator between them. That seems to be a proble
for excel. The only way possible seems to be to 'draw' the column
manually in the import wizard. I'd rather do it in an automatic way
because of the large amount of data.

Is there a simple solution to this problem? (I've got little excel an
programming background.)

Thanks a lot for any responses!!
 
N

Nick Hodge

Juliette

Why not record yourself doing it once (Tools>Macros>Record new macro...).
Changing the code to adapt for each input file should be relatively simple.

Post back if you need help with adapting the code resulting from the
recording

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top