Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |