Avatar of Conernesto
Flag for United States of America

asked on 

Excel Left formula

I need an Excel formula.  In Cell Q I have values as shown below. If there is a space on the text, I need the first values before the space. If there is now space I need the third and fourth digits from left to write.
Have                Want
USIL000016            IL
AL BIRMI                AL

Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon