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(M ID(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,1 0,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
"alexp" wrote in message
...
Alpha Phrase To Phone Number Calculator. Is there a way to convert text
to
phone numbers in excel. I need a formula. Like this example :
http://www.csgnetwork.com/phonenumcvtrev.html