find and replace

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

I have telephone numbers in this format 1234567899 and
want to replace them in this format 123-456-7899. Is
there any way to do that?
 
Stephanie,

I'm not sure that find replace is necessary, format the cells as custom and type in 000-000-0000

If that doesn't work for you,
=LEFT(A1,3) & "-" & MID(A1,4,3) & "-" & RIGHT(A1,4)
in an adjacent column and copy down

Dan E
 
Stephanie said:
I have telephone numbers in this format 1234567899 and
want to replace them in this format 123-456-7899. Is
there any way to do that?
Click to expand...

Format >> Cells >> Special >> Social Security Number
 
Back
Top