Delete rows

P

peterrebsamen

I have the following problem: In a column with the following 3 entries:
Cell A1 "CG Leimer Kurt PMU (02015)", Cell A2 "CG Vaz Pinto Gonçalo
(03187)", Cell A3 "CG PMU Insinger KS (60010)", I would like to
automatically delete all rows where in column A the letters PMU appear.
In other words, I would like excel to delete the first and the third
row. Since PMU does not appear in cell A2, I would like that excel
keeps this row. Any idea of an easy way to do this?
 
B

Bob Phillips

Peter,

Use Autofilter to select rows that contains PMU, and then just select the
visible rows and delete them. Then turn off Autofilter.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
M

Max

One way:

Insert a new row1

Put in B2: =IF(ISERROR(SEARCH("PMU",A2)),"Yes","No")

Copy B2 down as many rows as there is data in col A

Do an Autofilter on row1, col B > select "No"

Delete the filtered rows (these are the ones you don't want)

Remove Autofilter
 
P

peterrebsamen

sorry max, did not get the chance to answer you yesterday. your wa
worked perfectly. thanks very much
 
Top