Excel: find 'a' or 'b' in a cell

Question

Using the 'find' formula in Excel, is it possible to say find either 'a' or 'b' in a cell (without using vba)?

For ex;

A1 = 'West 1'

I tried Find(OR("1","2"),A1) but that threw an error.

Answer 1

You can use this array formula to returns first position of any character from the list:

=MIN(IFERROR(FIND({"1","2","3"},A1),""))

press CTRL+SHIFT+ENTER to evaluate it.

It returns 0 if nothing found.