| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for string containing
Hello,
I have the following in VBA: If .Cells(X, "K") = "RG" Then .Cells(X, "Q").Value = "TRC" How can I modify this formula to look in column K for a string that contains RG and perform the same function? (i.e., if it contains RG-TRVL or TRVL-RG, then TRC should automatically be placed in column Q)? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search string for number value | Excel Discussion (Misc queries) | |||
| How to search a string from the right ? | Setting up and Configuration of Excel | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| Q: search in string | Excel Discussion (Misc queries) | |||
| Segregating a Search String | Excel Discussion (Misc queries) | |||
Threaded Mode
