| 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. |
| 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 | |||
Threaded Mode
