Jan 31 2022 06:31 AM
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
Jan 31 2022 06:43 AM - edited Jan 31 2022 06:43 AM
SolutionJan 31 2022 06:58 AM
=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.
Jan 31 2022 06:59 AM
Jan 31 2022 06:43 AM - edited Jan 31 2022 06:43 AM
SolutionThat could be
=IF( ISERROR( LEFT(A1,6)*1 ), "", LEFT(A1,6)*1 )