| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can Search find 2 or more "/"?
Hi everyone,
I believe now I am asking too much. I use (as prescribed by this group) =ISNUMBER(SEARCH("/",D5)) to find "/" in a cell. I would like to extend this to find 2 or more instances (CM/F/CM), (F/F/F/) Right now it does not differentiate if is 1 or more instances. Is it possible? Thanks for any help, Emilio |
|
#2
|
|||
|
|||
|
One way:
=(LEN(D5)-LEN(SUBSTITUTE(D5,"/",""))) =2 In article , Wind54Surfer wrote: Hi everyone, I believe now I am asking too much. I use (as prescribed by this group) =ISNUMBER(SEARCH("/",D5)) to find "/" in a cell. I would like to extend this to find 2 or more instances (CM/F/CM), (F/F/F/) Right now it does not differentiate if is 1 or more instances. Is it possible? Thanks for any help, |
|
#3
|
|||
|
|||
|
You guys are magicians!
Thanks again, Emilio "JE McGimpsey" wrote: One way: =(LEN(D5)-LEN(SUBSTITUTE(D5,"/",""))) =2 In article , Wind54Surfer wrote: Hi everyone, I believe now I am asking too much. I use (as prescribed by this group) =ISNUMBER(SEARCH("/",D5)) to find "/" in a cell. I would like to extend this to find 2 or more instances (CM/F/CM), (F/F/F/) Right now it does not differentiate if is 1 or more instances. Is it possible? Thanks for any help, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the Find tool in EXCEL | Excel Worksheet Functions | |||
| How do I use "find" to search whole workbook? | Excel Discussion (Misc queries) | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
| HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA | Excel Worksheet Functions | |||
| how to change "Find" feature | Excel Worksheet Functions | |||
Linear Mode
