I have a text report I import into excel that has headers and blank rows between the headers.
I need some code to delete rows that begin with specific words, such as "subscriber", or "Payment type", and also deletes any blank rows.
Thanks
I have a text report I import into excel that has headers and blank rows between the headers.
I need some code to delete rows that begin with specific words, such as "subscriber", or "Payment type", and also deletes any blank rows.
Thanks
without code try this:
suppose your data is in column B (if not add a column at right of your data column), put 1 in column A to the right of cells that you want to delete (whole row) and also put 1 on right of cells that are empty, when you have entered 1 in the right of cells that you want to delete, select column A and press F5 to open Go To window > press Special tab and click Constants and then Ok. it will select cells that contain 1 (actually these cells are in rows that you want to remove) now press Ctrl+- (Ctrl and minus sign) it will open a Delete window, select Entire row and click Ok. All rows will be deleted which contain 1 in col A.
hope this would serve your purpose.
Originally Posted by Paulg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks