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,"(",""),")","" ),"-","")



"buccig" wrote:

i want to convert telephone number to regular number