Remove blank rows and text

Everyday I get an file (comma separated values) to which I got to transfer numeric data from it onto an Excel file. I open the first file as an excel file (delimited). In this file I have a row of text, a couple of rows of data that I need to transfer or copy and this is followed by a few blank rows and so on.

Can a macro be created to:
1. Delete the content of all the cells that contain only text.

2. Delete the rows that have only blank cells within a assigned number of row (ex. from 1 to 50)

Once this is done I can copy all the data needed at once and paste it into my second Excel file