Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Phone Dialer | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel |