Hi,

I have a txt file with a lot of data which im trying to export to excel. The
data is not seperated by any comma, space or anything. All the data is
together but i know how many characters goes into each cell of every column.
I dont want to go thru fixed length wizard as it takes a lot of time. Can
anyone help me with this plz?

EX: The format of the 1st line in txt file is
04MKK 9900000001/ 2INSUINSU23234563 / /
/ / / // /
/ //CRS Insured Name 1
CRS2 Insured Name 1
/ / / / /// / // 1100000001
M// /
New

I cannot consider spaces to delimt the file as there is no data for some
records in those spaces but some do. lets say the first cell of the 1st
column is 3 charachters, 1st cell of second column should have 2 char etc.
The ultimate format shld be like this

04M KK 9900000001 / /