Checking for the existence of a characted in a string

P

Peter Rooney

Whilst I'm being lazy, what's the best way to check for the existence of a
character (say "-") in a string?

My brain's gone to sleep this afternoon - sorry, y'all!
Thanks in advance

Pete
 
S

starguy

say you want to check ; in a cell, following formula will return yes i
it finds and no if it did not.

=IF(ISERROR(FIND(";",A1)),"not","yes"
 
Top