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)…
Related Posts

How to Sort Data but Keep Blank Cells in Excel

In daily work, if we sort data with blank cells included in the same column, these blank cells are listed at the bottom automatically after sorting. If we want to keep the positions of these blank cells unchanged and only ...

How to Copy and Paste Only Values and Ignore Formula

When we copy a cell applied with a formula, we copy the formula of the cell rather than copy the value showing in the cell. In this article we will introduce you the way to copy only value ignoring applied ...

How to Sort Date by Day of Week in Excel

Except sort data by “A to Z” (alphabetical order, for numbers from small to large), we can also sort data by date, month or year if these conditions are given. In this article, we will show you the way to ...

How to Select All Non-Blank Cells of a Range

In daily work, we may meet the cases that select all blank cells or non-blank cells of a range. You may know the way to select all blank cells as they are “blanks”. But for non-blank cells, they may contain ...

Fill Blank Cells with specific value (0 or null)
fill empty blank cell with value2

This post will teach you how to fill all blank cells with specific value, such as: 0 or any other values in excel. How to locate all blank cells and then fill in all the blanks with any specific value. ...

Delete Rows Based on Cell Value
remove rows based on values3

This post will guide you how to use the Find & Replace feature to delete or remove all rows based on certain cell value in Microsoft Excel. Or how to delete all rows that contain certain value with VBA code ...

How to Copy Formula without Changing Cell References
copy formula without changing reference7

This post will guide you how to copy formula without changing its cell references to make an exact copy in excel. How to copy and paste formulas or links without changing Cell References. How to copy exact formula from one ...

How to Check If the First Letter is capitalized
check if first letter capitalized4

This post explains that how to check if the first letter in a cell is capitalized or not in excel. How to write an excel Macro to check if the first letter in a specified cell is capitalized or not. ...

How to remove all spaces between numbers or words
remove spaces6

This post will describe two quick ways to remove all space characters between numbers or words in excel. How to remove unwanted spaces from cells in a select range of cells in Excel. Assuming that you have a list of ...

How to replace all characters after the first specific character
replace after first commas3

This post will guide you how to replace all characters after the first match of a specific character with a new text string in excel. How to replace all substrings after the first occurrence of the comma character with another ...

Sidebar