S Schizoid Man Nov 11, 2009 #1 Why does the following formula return TRUE? =ISTEXT(LEFT(A1,1)) where cell A1 contains the text "10Y".
Why does the following formula return TRUE? =ISTEXT(LEFT(A1,1)) where cell A1 contains the text "10Y".
P Peo Sjoblom Nov 11, 2009 #2 Because LEFT is a text function, this will work =ISTEXT(--LEFT(A1,1)) -- Regards, Peo Sjoblom
P Peo Sjoblom Nov 11, 2009 #3 Note that if the leftmost character is not a number the formula will be incorrect so it's better to use ISNUMBER instead =ISNUMBER(--(LEFT(A1,1))) will return TRUE for 10Y and FALSE for YYY -- Regards, Peo Sjoblom
Note that if the leftmost character is not a number the formula will be incorrect so it's better to use ISNUMBER instead =ISNUMBER(--(LEFT(A1,1))) will return TRUE for 10Y and FALSE for YYY -- Regards, Peo Sjoblom
