Alpha Phrase To Phone Number Calculator in excel

P

Peo Sjoblom

I am sure there are better ways but if you create a list with the letters in
a 2X26 table, i.e.

A 2
B 2
C 2
D 3
E 3
F 3
G 4

and so on, call the table Tbl then use this formula

=LEFT(G1,4)&VLOOKUP(MID(G1,5,1),Tbl,2,0)&VLOOKUP(MID(G1,6,1),Tbl,2,0)&VLOOKU
P(MID(G1,6,1),Tbl,2,0)&VLOOKUP(MID(G1,7,1),Tbl,2,0)&VLOOKUP(MID(G1,8,1),Tbl,
2,0)&VLOOKUP(MID(G1,9,1),Tbl,2,0)&VLOOKUP(MID(G1,10,1),Tbl,2,0)&VLOOKUP(MID(
G1,11,1),Tbl,2,0)


Where G1 is the cell that holds the phone text number


Regards,

Peo Sjoblom
 
Top