Alpha Phrase To Phone Number Calculator in excel
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 |
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 |
All times are GMT +1. The time now is 07:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com