I am sorry i meant fixed width in the text import wizard. the problem with
this is 1 row is gonna be split in to 130 colums with a fixed character
length in each cell of every column. So i was lookin for an alternative.
Thanks for your help

"Jim Rech" wrote:

So instead of doing the fixed | length,

I don't know what that means but the Text Import Wizard should pop up when
you open the file in Excel. You would choose 'fixed width' and then where
the breaks are.

--
Jim
"nick" wrote in message
...
| Hi,
|
| I have a Dat file which need to be pput in to excel. I know the # of
| characters( different for each cell) that need to go in every cell and
even
| the # of colums the data has to go in to. So instead of doing the fixed
| length, which takes a lot of time is there any function or program that i
cld
| use to convert the data in to excel by providing the conditions like 1st
cell
| i need 3 charactars from the dat file and the next 4 in 2nd and next 3 in
3
| etc
| EXAMPLE:
| DAT file is in the format
| 11113333444455556666
|
| I want this to be put in excel in the format:
| 1st cell with 4char: 1111
| 2nd cell with 3: 333
| 3rd with 5: 34444
|
| Etc........please help as this is very urgent. Thanks. I hope i framed the
Q
| right and understandable