How to edit text in colum

  • Thread starter Thread starter Michelle22
  • Start date Start date
M

Michelle22

I have a column of phone numbers listed as 1-555-555-5555 and need to format
it to 555-55-5555 (removing the 1-) and I can't find it anywhere. Can anyone
help? Thanks so much.
 
Michelle,

In another column, use the formula

=RIGHT(A2,LEN(A2)-2)

and copy down.

Unless the dashes are added by formatting...

HTH,
Bernie
MS Excel MVP
 
edit, replace"1-" with ""

Bernie Deitrick said:
Michelle,

In another column, use the formula

=RIGHT(A2,LEN(A2)-2)

and copy down.

Unless the dashes are added by formatting...

HTH,
Bernie
MS Excel MVP
Click to expand...
 
Back
Top