SOLVED

IF(LEFT(ISNUMBER statement

Occasional Contributor

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
best response confirmed by bfield66 (Occasional Contributor)
Solution

@bfield66 

That could be

 

=IF( ISERROR( LEFT(A1,6)*1 ), "", LEFT(A1,6)*1 )

 

So close! I returns just the first digit.

@bfield66 

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

Sorry, my mistake!! You are absolutely correct!!