Hi, I am importing a text file into excel, the one problem I have is that the text file comes from multiple pages and therefore I have at random intervals two blank rows plus one row that contains the headers from the subsequent pages of the text file.
Does anyone know how i can serch for these rows and delete them. Any help would be much appreciated
Regards
Paul
Does anyone know how i can serch for these rows and delete them. Any help would be much appreciated
Regards
Paul