ExcelBanter - View Single Post - delete row if text not in specific format

Thread: delete row if text not in specific format

View Single Post

#1

Report Post

Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

Abdul[_2_] is offline

external usenet poster

Posts: 137

Default

delete row if text not in specific format

Hi,

I have data in my column B

i want to delete all rows which are not in the specific format
00.000000.0000000.00.000.0000.0000

(zeros with any number)

thanks

Reply With Quote

Reply With Quote