Forum Discussion
Solved
IF(LEFT(ISNUMBER statement
I'm trying to use an IF statement to pull the left 6 characters, ONLY if they are numbers. Example below.
184412 MAIN FRAME UPDATE
4 Replies
=IF(SUM((LEN(LEFT(C4,6))-LEN(SUBSTITUTE(LEFT(C4,6),$A$4:$A$13,)))/LEN($A$4:$A$13))=6,LEFT(C4,6),"")
An alternative could be above formula as shown in the attached file. Enter formula with ctrl+shift+enter if you don't work with Office365 or 2021.
