| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thanks for the help. Works perfectly.
"Jason Morin" wrote: With entries in col. A, you could tag the entries in column B using: =IF(SUM(COUNTIF(A1,{"*brake*","*clutch*"}))=2,"b/c","") HTH Jason Atlanta, GA -----Original Message----- How do you search for multiple words in any given cell. The order of the words being searched does not matter. i.e. If I am looking for the words 'brake' and 'clutch': 1 "John's Brake and Clutch" 2 "Jerry's Clutch Repair" 3 "Impact Clutch/Brake" 4 "Brakes and Clutches r Us" If want the search to work for 1, 3, and 4. Any ideas? . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| space between text strings with concatenate | Excel Discussion (Misc queries) | |||
| Compare cells/columns and highlight matching text strings | Excel Worksheet Functions | |||
| How to make a cell recognize multiple text strings? | Excel Worksheet Functions | |||
| Searching for text in cells | Excel Discussion (Misc queries) | |||
| Filter long Text strings | Excel Worksheet Functions | |||
Threaded Mode
