| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find text in string
Hi. Within a loop, I would like for the macro to find the text "On Hand"
within a cell on a given row. If the text exists anywhere in the cell, I would like to delete the row. What command should I use? I know that if I wanted to find this in the left or right of the string I would use the LEFT or RIGHT function, but I don't know how to have it search anywhere in the string. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Find Specific Text in a Text String | Excel Discussion (Misc queries) | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| backwards find function to find character in a string of text | Excel Programming | |||
| How to Find text in String? | Excel Programming | |||
![Mike D.[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
