Hi,

This should be a simple question, but I can't get to the bottom of it.
I have imported a text file, but the data for every record is spread
over two rows. I need to extract data from every second row, i.e.:

=MID('Sheet2'!$A1,2,1)

However, I want to drag down so that the next formula reads:

=MID('Sheet2'!$A3,2,1)

I've been trying (and failing) to use the offset command for this.
The only other criteria is that I don't want to use a helper column if
possible as the resulting data will be automatically loaded onto a
system and I don't want to risk forgetting to delete the helper
column!

Thanks.
BH

Have your tried a combination of Row and Indirect:

=MID(INDIRECT("Sheet2!A"& ROUNDUP(ROW()*2-1,0)),2,1)


"Ben Hur" wrote in message
...
Hi,

This should be a simple question, but I can't get to the bottom of it.
I have imported a text file, but the data for every record is spread
over two rows. I need to extract data from every second row, i.e.:

=MID('Sheet2'!$A1,2,1)

However, I want to drag down so that the next formula reads:

=MID('Sheet2'!$A3,2,1)

I've been trying (and failing) to use the offset command for this.
The only other criteria is that I don't want to use a helper column if
possible as the resulting data will be automatically loaded onto a
system and I don't want to risk forgetting to delete the helper
column!

Thanks.
BH