Eliminate #VALUE! in Formula Result
One mo
=IF(COUNT(FIND("/",C30)),"Yes","No")
--
Biff
Microsoft Excel MVP
"Roy A." <Roy wrote in message
...
=FIND("/",C30)
If the above formula does not find the slash #VALUE! is returned. How do I
eliminate that result and obtain a number?
I am attempting to setup a telephone directory for a condominium
association. I am attempting to obtain TEXT following the slash using the
MID
function. Most of the text I am searching does not contain a slash.
If anyone has a template that might assist me in this endeavor, it would
be
greatly appreciated.
|