What function do I use to find parts of words in a column that contains both text and numbers? For example, the word "Appetiser" may be in B120, but as you can see it is spelled wrong, so I would set up the search for "App".
I want something that is NOT case sensitive. Therefore, if someone typed it in as APPETIZER, or appetizer, I want it to return a value for finding "APP" or "app" in the column. Preferably, a count of the number of times it finds it would be preferred. However, when I used:
I get a value of 0 because "app" is not the exact value that was entered. For some reason, SEARCH and FIND aren't working for me.
I would like to get either a true/false return when it finds an "app", or more preferably, a count of the number of times it finds "app" in the same column, even if the "app" is part of another word.