software

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

gt;gt;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
quot;nickquot; gt; 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
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

quot;Jim Rechquot; wrote:

gt; gt;gt;So instead of doing the fixed | length,
gt;
gt; I don't know what that means but the Text Import Wizard should pop up when
gt; you open the file in Excel. You would choose 'fixed width' and then where
gt; the breaks are.
gt;
gt; --
gt; Jim
gt; quot;nickquot; gt; wrote in message
gt; ...
gt; | Hi,
gt; |
gt; | I have a Dat file which need to be pput in to excel. I know the # of
gt; | characters( different for each cell) that need to go in every cell and
gt; even
gt; | the # of colums the data has to go in to. So instead of doing the fixed
gt; | length, which takes a lot of time is there any function or program that i
gt; cld
gt; | use to convert the data in to excel by providing the conditions like 1st
gt; cell
gt; | i need 3 charactars from the dat file and the next 4 in 2nd and next 3 in
gt; 3
gt; | etc
gt; | EXAMPLE:
gt; | DAT file is in the format
gt; | 11113333444455556666
gt; |
gt; | I want this to be put in excel in the format:
gt; | 1st cell with 4char: 1111
gt; | 2nd cell with 3: 333
gt; | 3rd with 5: 34444
gt; |
gt; | Etc........please help as this is very urgent. Thanks. I hope i framed the
gt; Q
gt; | right and understandable
gt;
gt;
gt;


So you need to import a text file.
Row 1 needs to be parsed in one way.
Rows 2 need to be parsed a different way.

I think I would do it like this:
1) Import file, placing column breaks where you want the 1st row
parsed.
2) Delete rows 2
3) Import file again, placing column breaks where you want rows 2
parsed and tell it to start import at row 2. Be sure to place the
imported file in the row below where you put the first row.

Will that work?--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: www.excelforum.com/member.php...oamp;userid=22181
View this thread: www.excelforum.com/showthread...hreadid=518315