Excel : get provider name of Vietnamese phone number

function.md

Replace A1 with your cell

Beatiful version

=IF(
    MID(A1,2,1)="9",
    IF(
        OR(MID(A1,3,1)="6",MID(A1,3,1)="7",MID(A1,3,1)="8"),
        "VIETTEL",
        IF(
            OR(MID(A1,3,1)="0",MID(A1,3,1)="3"),
            "MOBI",
            IF(
                OR(MID(A1,3,1)="1",MID(A1,3,1)="4"),
                "VINA",
                ""
            )
        )
    ),
    IF(
        MID(A1,2,2)="16",
        "VIETTEL",
        IF(
            OR(MID(A1,2,3)="120",MID(A1,2,3)="121",MID(A1,2,3)="122",MID(A1,2,3)="126",MID(A1,2,3)="128"),
            "MOBI",
            IF(
                OR(MID(A1,2,3)="123",MID(A1,2,3)="124",MID(A1,2,3)="125",MID(A1,2,3)="127",MID(A1,2,3)="129"),
                "VINA",
                ""
            )
        )
    )
)

One-line version

=IF(MID(A1,2,1)="9",IF(OR(MID(A1,3,1)="6",MID(A1,3,1)="7",MID(A1,3,1)="8"),"VIETTEL",IF(OR(MID(A1,3,1)="0",MID(A1,3,1)="3"),"MOBI",IF(OR(MID(A1,3,1)="1",MID(A1,3,1)="4"),"VINA",""))),IF(MID(A1,2,2)="16","VIETTEL",IF(OR(MID(A1,2,3)="120",MID(A1,2,3)="121",MID(A1,2,3)="122",MID(A1,2,3)="126",MID(A1,2,3)="128"),"MOBI",IF(OR(MID(A1,2,3)="123",MID(A1,2,3)="124",MID(A1,2,3)="125",MID(A1,2,3)="127",MID(A1,2,3)="129"),"VINA",""))))```

New version

=IF(OR(A1="086",A1="096",A1="097",A1="098",A1="032",A1="033",A1="034",A1="035",A1="036",A1="037",A1="038",A1="039"),"Viettel",IF(OR(A1="089",A1="090",A1="093",A1="070",A1="079",A1="077",A1="076",A1="078"),"Mobi",IF(OR(A1="088",A1="091",A1="094",A1="083",A1="084",A1="085",A1="081",A1="082"),"Vina","Other")))