| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the best way to query a range for a substring?
I can't seem to find a function to find cells with a particular portion of a
string in them (much like a SQL query using LIKE). Is there such a function? If there is no such function then what would be the most efficient way to do this? I need to search a colum for several different values and then move 1 cell to the right and grab the value there. So fo example: SAU #1 - test 12 SAU #2 - development 25 SAU #3 - specs 12 So in the example I need the values of 12,25,12 but for the text in the first column the only known part that will be there is the first part (i.e. "SAU #1 -") Can Column.Find use a wildcard? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Doing a countif against a substring of the range to be scanned | Excel Worksheet Functions | |||
| Count the number of cells in a range with a string containing a specified substring | Excel Programming | |||
| Count the number of cells in a range with a string containing a specified substring | Excel Programming | |||
| Counting occurences of a substring in a range of cells. | Excel Worksheet Functions | |||
| Searching for a substring in a range | Excel Programming | |||
Threaded Mode
