An "ISNA" function for #value! ?

[Rebam98]

Hi,

Is there a function that works like "isna" does for the N/A error but for #value?

I'm doing a search on a column to look for a hyphen within a string of text. Anything before that hyphen I want to extract. The problem is not all strings have a hyphen. Therefore, when I do a search for the hyphen, it returns, "#value!". I'd like to write an "if" statement looking for the "#value!" and have it make a decision on if #value! is true or not.

 

[Rebam98]

Disregard, I found it, "iserror"

 

[Peter_SSs]

Rebam98

Here a couple of options you might consider. If this is not what you meant, post back with more details.

B1 (copied down): =IF(ISNUMBER(FIND("-",A1)),LEFT(A1,FIND("-",A1)-1),A1)
C1 (copied down): =LEFT(A1,FIND("-",A1&"-")-1)

Mr Excel.xls
	A	B	C	D
1	What about - this?	What about	What about
2	no hyphen	no hyphen	no hyphen
3	sub-total	sub	sub
4
Search Hyphen

 

[Rebam98]

Thanks Peter! Solution found.