is there an ISIN function to test for the presence of a character or text string in a cell

the title says it all. looking for the "-" to let me know to take the right 5 or right 10 characters out of an address string for the zip code.

I think i could do it this way:

=IF(LEFT(RIGHT(K2,5),1)="-",RIGHT(K2,10),RIGHT(K2,5)

but thought there might be a simple function to interrogate a cell for a certain character, e.g. =ISIN(K2,"-")

thanks

brian

The following tests for "-" within K2, and will return "false" if it finds "-" anywhere within K2, not just in the Nth position.

=IF(ISERROR(FIND("-",K2),RIGHT(K2,5),RIGHT(K2,10))

Assuming the "-" always appears 5 digits from the right, your formula seems to do the trick.