how to automatically remove text data among stock prices?

Hi, every one here. I would be very grateful if anyone could help me to solve the problem. my problem is:
I have worksheet for importing stock prices from yahoo, but every time when the worksheet refreshed for updating data, there are many text data like words"split","date".etc came together among prices. is there any way to remove such thing automatically. thanks.

E

Thanks so much. Your code perfectly solved my problem and very efficient, it reduce my too many work for deleting each text line, now I just highlight each sheet and run your macro . Since I have over 100 stocks in different sheets (over 100 sheets), there is any way for your macro to run automatically. For example, every day when I open the file, all data in each sheets automatically updated, how can the macro can automatically highlight all sheets and run your macro? Thanks so much.

Hi, thanks so much for your help. after use your second macro, there is a problem occur. The first macro code no longer work like before. it can't remove symbol *, if I add * in the list, it removed all data I highlighted.
second problem is the text removed, but left blank rows among the data, how to delete the blank rows after removing text from them.
My main purpose is to delete all the rows which contain text, like picture attached, I want delete row 68 and row 69.
123.PNG


Thanks.

Only my guess

Please Login or Register  to view this content.

Thanks so much for your great help. This is perfect one.