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...