How to Insert Dashes in Phone Numbers in Excel

This post will guide you how to insert or add dashes in phone number with a formula in Excel. How do I add dashes to telephone numbers in a selected range in Excel. How to separate numbers with dashes in Excel.

Insert Dashes into Phone Numbers


Assuming that you have a whole list of phone numbers that have no dashes or spaces. And you need to insert dashes into those phone numbers in a selected range of cells. And you also want to add dash after the 3rd and 6th numbers in each phone number in Excel. How to do it.

You can use a formula based on the REPLACE function to achieve the result. Just like the following formula:

=REPLACE(REPLACE(B1,4,0,”-”),8,0,”-”)

Type this formula into a blank cell and press Enter key. And then drag the AutoFill handle over to other cells to apply this formula.

inset dash phone number2

Insert Dashes into Phone Numbers Using Format Cell


You can also use the Format Cell feature to achieve the same result of adding dash into phone number in Excel. Here are the steps:

#1 select range of cells that you want to insert dashes in.

inset dash phone number3

#2 right click on it, and select Format Cells from the popup menu list. And the Format Cells dialog will open.

inset dash phone number14

#3 Click Number tab in the Format Cells dialog, and select Custom under Category list box, and type the following format code into the Type text box.

###-###-####

inset dash phone number15

#4 click Ok button. You would notice that all phone numbers have been inserted dashes in the selected range of cells.

inset dash phone number1

 Related Functions


  • Excel Replace function
    The Excel REPLACE function replaces all or part of a text string with another text string.The syntax of the REPLACE function is as below:=REPLACE (old_text, start_num, num_chars, new_text)…

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar