DAT to XLS
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
|