How to add dashes in contact phone number in excel ?

Asked By 50 points N/A Posted on -
qa-featured

I have received detail of my clients in excel sheet, and their phone numbers are in unformatted form (ex: 1231231234) in excel sheet,I want data in formatted (ex: 123-123-1234 ) form. My query is how to add dashes in contact phone number??

SHARE
Best Answer by Sinky Kramer
Best Answer
Best Answer
Answered By 0 points N/A #140704

How to add dashes in contact phone number in excel ?

qa-featured

Good day! Here is a simple solution for you.

On your excel spread sheet:

1. Highlight all the numbers you want to be formatted.

2. Right click and click on "Format Cells"

3. Under the "numbers" tab, you will see "custom" Click on it.

4. After clicking Custom, you will be able to see "type:" and a text box below it. 

5. Type this code in it: _(#-####-#0_)

6. Click OK

7. You will be able to see the numbers are now formatted in this form 1111-1111-11

 

Thanks!

Answered By 0 points N/A #140705

How to add dashes in contact phone number in excel ?

qa-featured

Adding dashes (-) in phone numbers on excel sheet is easy. Just select the column on which the phone numbers are located. Then right click on it and then “Format cells”. Click on “Custom” and type ###-###-#### and finally click ok. You are done.
You may use formula too. If your first number is in C1, put this in D1 and copy down:
=LEFT(C1,3)&"-"&MID(C1,4,3)&"-"&RIGHT(C1,4) .

Login/Register to Answer

Related Questions