| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find multipule text strings within a cell
=IF(ISNUMBER(SEARCH("PREP",E1036)),"PREP","") &
IF(ISNUMBER(SEARCH("BORE",E1036)),"BORE","") -- Gary''s Student - gsnu200817 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find common strings of text then copy those rows elsewhere? | Excel Worksheet Functions | |||
| Splitting Text strings in one cell | Excel Discussion (Misc queries) | |||
| linking four cell with multipule colums with other worksheet | Excel Worksheet Functions | |||
| How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
| How to make a cell recognize multiple text strings? | Excel Worksheet Functions | |||
Hybrid Mode
