IF(LEFT(ISNUMBER statement

[bfield66]

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

[#2 · Accepted solution]

@bfield66 

That could be

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

[#3]

So close! I returns just the first digit.

[#4]

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

[#5]

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