Checking for the existence of a characted in a string
 

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

Checking for the existence of a characted in a string
 

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

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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=553633

Checking for the existence of a characted in a string
 

Good morning,
This works a treat.
Thanks very much

Pete

"starguy" wrote:


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

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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=553633