Your welcome Paul, glad you got it working.

Regards
Martin



"Paul_of_Abingdon" wrote in
message ...
Martin:

Thank you VERY much. It worked. I appreciate very much. It helped me a lot
because I have so many files like that.

Sincerely,

Paul of Abingdon

"MartinW" wrote:

Hi Paul,

One way,

Put 1 into B1
Highlight B1 and B2
Grab the fill handle and drag down to row 4000
That should leave 1 blank 2 blank 3 blank...etc in col B
Put =INDIRECT("A"&B1) in C1
Grab the fill handle and drag down to C4000 (or just double click it)
That should leave your column A data in column C
separated by the #REF error.


Whilst column C is still selected
Tap F5SpecialFormulas
Uncheck Numbers, Text and Logicals and leave
Errors checked.
OK out
Then tap delete


Do a CopyPaste Values on column C
and delete columns A and B

HTH
Martin


"Paul_of_Abingdon" wrote in
message ...
I have an excel file with 2000 records. Is there anyway I can insert
blank
rows after each records?