Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Use
=IF(ISERROR(SEARCH(" and ",C2)),"",LEFT(C2,SEARCH(" and ",C2))) to avoid the error you are getting "Mctabish" wrote in message news:MXBAd.722502$mD.346465@attbi_s02... 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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Hi
one way: =IF(COUNTIF(C2,"* and *"),LEFT(C2,SEARCH(" and ",C2)),"") -- Regards Frank Kabel Frankfurt, Germany "Mctabish" schrieb im Newsbeitrag news:MXBAd.722502$mD.346465@attbi_s02... 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 |
Reply |
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 |