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 )

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
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