MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Look for a character in a range


Posted by Travis on October 03, 2001 8:30 PM

Is there a way to look for a character within a range of cells?

For example if there is a "?" in A1:D10 then True else Flase. Where the values in A1:D10 can be text numbers or formulas.


Posted by IML on October 04, 2001 6:25 AM

YOu could use the array formula:
=OR(ISNUMBER(SEARCH("~?",A1:D10)))

For a non-wild character, there is no need to proceed it with the tilde.

When you paste this formula in, hit F2, and then be sure control and shift and depressed while hitting enter.

Good luck