Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to avoid the #Value! result in a formula?
I am trying to test for the word " and " in a cell. If the word is there,
everything is fine. However, if the word is not there, I get a #value! error. Here is the formula I have =IF(SEARCH(" and ",C2)0,LEFT(C2,SEARCH(" and ",C2)),"") Column C has names and if married, the spouses name. I am trying to separate these in to differant coulmns. The results of the above would be the extracted spouses name Thanks, Mctabish |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Amount or Numbers in Words | New Users to Excel | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |