Excel VBA FORMULA

[rameshca550]

I have unique id numbers starting with area code in the ID
E.g. 3321105156755 where 33211 is East-1is area and 05 is the locality i need formula to extract this two elements and get the direct name in other column my data will be
Code. Area. locality
3321105252535. East-1
3321406352535. HP
3321308355689. SH PET
3321205656572. EAST-2
Where
First t
Four digit is
33211= East-1
33212= East-2
33213= Shpeta
33214= HPURAM
I HAVE ONLY 4 area and I'd number all ways is a 13 digit number
Coming to locality i have 22 I add them when u give u vba formula for example 05 next 2 digits 05= mis
06=kmp
Plz give me two vba formula for area and locality

 

[mikerickson]

Given a code number like 3321105156755 in A1, one can extract the code for the area and the locality with formulas like

=LEFT(A1,5)
=MID(A1, 6, 2)

Converting those sub-code numbers into text could be done with a VLOOKUP array.