Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Eliminate #VALUE! in Formula Result
=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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Eliminate #VALUE! in Formula Result
=IF(ISERROR(FIND("/",C30)),C30,your_mid_formula)
-- Gary''s Student - gsnu200773 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Eliminate #VALUE! in Formula Result
"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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to Replace or eliminate any sheetname(s) in formula string | Excel Discussion (Misc queries) | |||
What formula will eliminate the cell with #N/A when summing? | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |