Tip Printed from ExcelTip.com
Find if a character is in a range in Microsoft Excel


The following characters appear in cell A1:A4

A1
Salaries
A2
Rent
A3
Fuel
A4
Total ?

The search term we are searching for is the question mark - ?

Enter the following formula in cell B1: =SUMPRODUCT(ISNUMBER(SEARCH("~?",A1:A4))+0)>0

The result: True