I'm trying to write a formula that says if the 8th character in my string (from the left) is either the number 1 or a letter, then return the left 8 characters, if not, return the left 7. However, when I use this it always returns 8 characters no matter what. What am I doing wrong? (I'm entering this formula in cell A1):
=IF(OR(LEFT(B1,8)=1,ISTEXT(LEFT(B1,8))),LEFT(B1,8),LEFT(B1,7))
Thank you!
=IF(OR(LEFT(B1,8)=1,ISTEXT(LEFT(B1,8))),LEFT(B1,8),LEFT(B1,7))
Thank you!