Eliminate #VALUE! in Formula Result

=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.

Dave
Sat Mar 15 11:12:32 CDT 2008

=if(isnumber(find("/",c30)),find("/",c30),"not found")

Change "not found" to whatever you want
--including a simple 0 or an empty string: ""



Roy A. wrote:
>
> =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.

--

Dave Peterson

GarysStudent
Sat Mar 15 11:14:00 CDT 2008

=IF(ISERROR(FIND("/",C30)),C30,your_mid_formula)
--
Gary''s Student - gsnu200773

RoyA
Sat Mar 15 11:20:03 CDT 2008



"Gary''s Student" wrote:

> =IF(ISERROR(FIND("/",C30)),C30,your_mid_formula)
> --
> Gary''s Student - gsnu200773

Thank you Gary that worked perfectly. I was using the same formula but I did
not have the second closing parathesis after the first find. I must be having
a memory lapse.
Thanks again.

T
Sat Mar 15 12:16:03 CDT 2008

One more:

=IF(COUNT(FIND("/",C30)),"Yes","No")


--
Biff
Microsoft Excel MVP


"Roy A." <Roy A.@discussions.microsoft.com> wrote in message
news:0D108351-3F63-438C-8624-787200BFF5ED@microsoft.com...
> =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.