"nick" wrote in message
...
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 / /




TIME OUT! HANG ON A MINUTE! The presence of the slashes makes absolutely no
sense. Is it possible that THOSE are your delimiters? Right now, just for
grins, try using Excel's delimited import method. On the 2nd screen, unclick
TAB, click Other, and put a slash in the box to the right of other.

You said those slashes existed as data, but why? It makes no sense, if the
sample above is any indication. What possible meaning could all those
slashes have?