Hi. I searched the forums but couldn't come up with a thread that dealt with this issue.

I have a telephone log text file (.dat) that is not separated by commas and that is about 12,000 rows high. Each row is filled with the phone number, dates, time, cost, etc. If the file had only one header, I would know how to convert it to a usuable format to extract the phone numbers (text to columns).
I need to extract the phone numbers w/o having to manually delete the headers (7 rows high) every 21 lines. This will take forever. Basically, for every 21 rows of data, I need to discard the first 7 rows and keep the next 14 and so on.

header (discard)
header (discard)
header (discard)
header (discard)
header (discard)
header (discard)
header (discard)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
date time xxx xxx xxxx location cost (keep)
(repeat)

I tried recording a macro but it doesn't work the way I want it to. It'll keep deleting the same range of cells, and the macro won't move on down the page.

I greatly appreciate any guidance on this. Thanks.