FIND FUNCTION 1

[fbacchus]

Hi:

The FIND function provided th location of the seach string within another string. For example if I was look for the position of "7" in a string containing NNQXI, FSRTZ 718-555-1212, the result would be 14 based on the following:

=FIND("7",A1, 1) - assuming that my data was in A1.

How do I use the same Or different function to check the position where the search string is a "7" or a "(" or a "2" or a "5" ? Thanks in Advance.


fb

 

[SkipVought]

hi,
[tt]
=IF(ISERROR(FIND("7",A1,1)),IF(ISERROR(FIND("(",A1,1)),IF(ISERROR(FIND("2",A1,1)),IF(ISERROR(FIND("5",A1,1)),FIND("5",A1,1),0),FIND("2",A1,1)),FIND("(",A1,1)),FIND("7",A1,1))[/tt]

Skip,
[sub]
[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen![/sub]