Forum Discussion
Phone Number in excel
I want to change a phone number from (555) 555-5555 to 15555555555 how can you do this in excel? I have about 1,000 numbers that I need to change. I have tried data numbers but won't change?
johnathancarlson Suppose your phone numbers are in column A, starting at A1, try this:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",1),") ",""),"-","")
and copy the formula down as far as needed.