phone number

**domvar22** · 09-03-2009, 04:40 PM

I have phone number is a cell ???-???-????, I need it to look like this (???)???-????. I have tried, but I can not seem to get rid of the 1st hyphen.

**shg** · 09-03-2009, 04:42 PM

Use Find and Replace to delete all hyphens, and then Format > Cells > Number, Special, Phone Number

**NBVC** · 09-03-2009, 04:43 PM

Try:

="("&REPLACE(A1,4,1,")")

where A1 contains original number.

You can then copy this column and go to original column, and then Edit|Paste Special and select Values.... then delete the helper column of formulas

**domvar22** · 09-03-2009, 04:44 PM

sorry, rookie mistake, i need it for a group of cells.

**domvar22** · 09-03-2009, 04:47 PM

Awesome NBVC, Just what I needed. thank you

**NBVC** · 09-03-2009, 04:52 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save