You guys nailed it... Thanks Max and Dave. I appreciate your help.
Tony

"Dave Peterson" wrote:

=if(isnumber(find("...",f3)),find("...",f3)-1,"not found")
or
=if(iserror(find("...",f3)),"not found",find("...",f3)-1)



Tony S. wrote:

Please help me with my formula to eliminate the "#VALUE"

=FIND("(R(9997 - 9998)",F3)-1

When I try to add =IF(ISERROR to this formula, I alway get a error or
missing parens or formula to short or contains an error. I know it's my
syntax but I can figure out where.

Thanks!

--

Dave Peterson