Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting row with specific value
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting row with specific value
try sorting and then deleting. Record a macro if desired.
-- Don Guillett SalesAid Software "Jed" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting row with specific value
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |