View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roy A. Roy A. is offline
external usenet poster
 
Posts: 1
Default 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.