bfield66Copper ContributorJan 31, 2022SolvedIF(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 SergeiBaklanJan 31, 2022bfield66 That could be =IF( ISERROR( LEFT(A1,6)*1 ), "", LEFT(A1,6)*1 )
SergeiBaklanDiamond ContributorJan 31, 2022bfield66 That could be =IF( ISERROR( LEFT(A1,6)*1 ), "", LEFT(A1,6)*1 )
bfield66Copper Contributor to SergeiBaklanJan 31, 2022So close! I returns just the first digit.bfield66Copper Contributor to bfield66Jan 31, 2022Sorry, my mistake!! You are absolutely correct!!
