» Find if a character is in a range in Microsoft Excel

CATEGORY - Excel Text Formulas VERSION - All Microsoft Excel Versions

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

Book Store:

VIEW ALL BOOKS

Recommended Books:

Email Tip

Print Tip

Add to My Tips

Rate This Tip



1	2	3	4	5

Rating: 3.48 Views: 48183

Excel 95 Formula.Find

Peter Earl Posted on: 31-12-1969

I perform a search for the characters 'T10' within a named range of cells. There is no 'T10', but there is 'T100'. The formula retrns true. How do I use this formula to search for exact?

Cheers - Pete

Reply: Excel 95 Formula.Find - Peter Earl from Australia wrote on September 5, 2003 12:58 AM EST

Alan Posted on: 31-12-1969

Hi Peter,

My approach would be to search for 'T10' and also search for 'T100', then use a formula to check for occurances of one without the other.

HTH,

Alan.