Hello,
I am having trouble combining these two formulas into one. I thought I could use something like this:
=IF(ISERROR(REPLACE(LEFT(A85,FIND(" ",A85,FIND("CAT",A85)+1)-4),1,FIND(" ",A85),"")),REPLACE(LEFT(A85,FIND(" ",A85,FIND("HOUSE",A85)+1)-6),1,FIND(" ",A85),""),REPLACE(LEFT(A85,FIND(" ",A85,FIND("CAT",A85)+1)-4),1,FIND(" ",A85),""))
But when I do, it only works correctly when the string “CAT” is found. There are three options:
If A85 has Cat, House, or neither.
Any help is appreciated
I am having trouble combining these two formulas into one. I thought I could use something like this:
=IF(ISERROR(REPLACE(LEFT(A85,FIND(" ",A85,FIND("CAT",A85)+1)-4),1,FIND(" ",A85),"")),REPLACE(LEFT(A85,FIND(" ",A85,FIND("HOUSE",A85)+1)-6),1,FIND(" ",A85),""),REPLACE(LEFT(A85,FIND(" ",A85,FIND("CAT",A85)+1)-4),1,FIND(" ",A85),""))
But when I do, it only works correctly when the string “CAT” is found. There are three options:
If A85 has Cat, House, or neither.
Any help is appreciated