inserting blank rows in between rows with data

[hinchah]

i have about 400 rows filled with data. in order for my formula to work i need to insert a blank row in between all 400 rows. does anyone know the answer to this without creating a macro??

-thanks
This message was edited by hinchah on 2002-10-25 21:45

 

[plettieri]

Hi

I think (?) there is a feature on ASAP-utilities.com that will do this very nicely...free download...also have a lot of other good stuff


hope this helps...

pll
This message was edited by plettieri on 2002-10-25 22:04

 

[zacemmel]

This formula will do it, but it's rather tedious to write a formula for something that can be doen so easily with a macro:

=IF(((ROW()+1)/2)=ROUND((ROW()+1)/2,0),OFFSET($A$1,((ROW()+1)/2)-1,0),"")

 

[hinchah]

that asap tool worked awesome. thanks so much.