Forum Discussion

bfield66's avatar
bfield66
Copper Contributor
Jan 31, 2022
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
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 31, 2022

    bfield66 

    That could be

     

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

     

bfield66's avatar
bfield66
Copper Contributor
Jan 31, 2022
So close! I returns just the first digit.
bfield66's avatar
bfield66
Copper Contributor
Jan 31, 2022
Sorry, my mistake!! You are absolutely correct!!

Resources