Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. -- ERR229 "Jed" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
Deleting specific records from a column | Excel Discussion (Misc queries) | |||
Deleting Specific Rows | Excel Discussion (Misc queries) | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |