i want to convert telephone number to regular number
W will A Feb 7, 2006 #2 FORMAT, CELL, GENERAL JMB said: If your data is in cell A1, enter this in B1 and copy down, then you could copy/paste special values. =--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),"-","") Click to expand...
FORMAT, CELL, GENERAL JMB said: If your data is in cell A1, enter this in B1 and copy down, then you could copy/paste special values. =--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),"-","") Click to expand...
