Forum Discussion
Search In option now only shows formula, not Look in Values
I recall being able to use the find/replace option and there would be the option to look in formula and also to look in values. Added to this, I would have used the ^# wildcard to search for a singl...
hi - here you are finding the explicit text ^#.
As Hans has indicated, using the wildcard searchonly works in word (where the wildcard pattern ^# = 1 single numeric character and ^#^#^# = 3 numeric characters)
I must be misremembering however, as I was so sure this wildcard search existed in excel also.
As Hans has indicated, using the wildcard searchonly works in word (where the wildcard pattern ^# = 1 single numeric character and ^#^#^# = 3 numeric characters)
I must be misremembering however, as I was so sure this wildcard search existed in excel also.
- I would suggest you using the most recent array formula such as FILTER() where is possible return de disired output.