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??
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!
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) .
