Using FIND with multiple criteria

[kyjae]

Hi All,

I have a problem using FIND to search for multiple strings in a cell.

For example, cell A1 contains a person’s name including their title (i.e. Mr, Miss, Ms, Mrs, Dr).

In Cell B1 I want to return a zero if no match is found and a 1 if it is. This works fine for one criteria, e.g. finding the word “Mr” with the following formula

=IF(ISERROR(FIND("Mr",A1,1))=TRUE,0,1)

However, I can’t work out how to amend the formula to find “Mr”, “Miss”, “Ms”, “Mrs” or “Dr” in cell A1 and return a 1 if found or a zero if not found.

It may be that the FIND function is not the most appropriate method. Can anyone point me in the right direction please?

Many thanks.

[Brendan_Floyde]

This assumes the title is at the very left of the text string

Please Login or Register  to view this content.

[kyjae]

Thanks Brendan,

Works a treat. I never of thought of using OR