Deleting row with specific value

[Jed]

Could some kind soul please advise syntex (macro)for deleting a row if first
3 character of a cell contains "FST"
I have some value in column "H" which contains value FST,FST1,FST2 and so
on. What i want to do is that if first 3 chracters in column "H" has a value
"FST" then i want to delete that row.

Thanks in advance

Regards
Jed

 

[Don Guillett]

try sorting and then deleting. Record a macro if desired.

 

[Guest]

Hi Jed,

I don't think you need code. Use AutoFilter and choose Custom. Then from the
drop-down choose Begins with and enter FST you'll limited the displayed data.

Once you've filtered you can simply select and delete the rows.