Forum Discussion

Oliullah_Siddique's avatar
Oliullah_Siddique
Brass Contributor
Jun 21, 2022
Solved

Formulas and Functions

Dear Everyone,   Riny_van_Eekelen    Would you please help me with the following formula,       A B C   Particulars Criteria Result 1 101010100000 If 1st digit of Cell A...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 21, 2022

    Oliullah_Siddique You can do that in several ways. I've included just two of them in the attached workbook. It all depend a bit on how much data yo have, how often you need to change codes etc.

     

    In general, I prefer the solution with a lookup table. The formula get easier to write and read and it easier to maintain.

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jun 21, 2022

Oliullah_Siddique 

Here is an approach for A1 because you could switch to the other lines.
Maybe it helps 🙂

=IF(MID(A1,1,1)="1",IF(MID(A1,3,1)="1","CA",""))

 

...if it's not what you're looking for, please just ignore it 🙂

 

 

 

Resources