Limitation in IsError function.

[Zeema]

Why does the following formula only works for cell lengths below 7?
=IF(ISERROR(LEFT(A2, FIND("-",A2)-1)),A2)

I am trying to pull portion of the product name to look for SDSs. The formula worked fine till the "Product ID" became longer than 7.

Example: SDS Name =IF(ISERROR(LEFT(D3, FIND("-",D3)-1)),D3)

Length	SDS Name	Product Constituent	Product ID
6	SHS125	13%	SHS125
10	FALSE	55%	LOC218-275
4	PA75	75%	PA75
4	KH45	100%	KH45

 

[Sam_D_Ben]

Please try this,

Book1
	A	B	C	D	E
1	Length	SDS Name	Product Constituent	Product ID	SDS Name
2	6	SHS125	13%	SHS125	SHS125
3	10	FALSE	55%	LOC218-275	LOC218
4	4	PA75	75%	PA75	PA75
5	4	KH45	100%	KH45	KH45
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=IFERROR(LEFT(D2, FIND("-", D2)-1), D2)

 

[Scott Huish]

You have Excel 365, why not:
=TEXTBEFORE(D2&"-","-")

 

[MARK858]

The posts above are the way to go, but just for your info you are getting the FALSE because you haven't put in the formula what you want to happen if there isn't an error

Book1xxxx.xlsb
	A	B	C	D
1	Length	SDS Name	Product Constituent	Product ID
2	6	SHS125	13%	SHS125
3	10	LOC218	55%	LOC218-275
4	4	PA75	75%	PA75
5	4	KH45	100%	KH45
Sheet11

Cell Formulas
Range	Formula
B2:B5	B2	=IF(ISERROR(LEFT(D2, FIND("-",D2)-1)),D2,LEFT(D2, FIND("-",D2)-1))

or more sensibly....

Book1xxxx.xlsb
	A	B	C	D
1	Length	SDS Name	Product Constituent	Product ID
2	6	SHS125	13%	SHS125
3	10	LOC218	55%	LOC218-275
4	4	PA75	75%	PA75
5	4	KH45	100%	KH45
Sheet11

Cell Formulas
Range	Formula
B2:B5	B2	=IF(ISERROR(FIND("-",D2)),D2,LEFT(D2, FIND("-",D2)-1))

Edit: just bolded the relevant part of the formula

 

[Peter_SSs]

Another slight 365 variation

=TEXTBEFORE(D2,"-",,,1)