How To Remove Dashes In Excel

Use the SUBSTITUTE function in Excel to remove dashes from a selected range of cells.

In the world of spreadsheets and data analysis, Microsoft Excel is undoubtedly one of the most popular tools. Whether you’re a business professional or a student, chances are you’ve encountered Excel at some point in your life. While Excel offers a multitude of features and functions to manipulate and analyze data, dealing with unwanted characters, such as dashes, can sometimes be a challenge. In this blog post, we will guide you through the process of removing dashes in Excel, allowing you to clean up your data and work more efficiently. So, if you’ve ever found yourself frustrated with dashes cluttering your Excel sheets, keep reading to discover some handy techniques and tricks to eliminate them once and for all.

How To Remove Dashes In Excel: Step-by-Step


Step 1: Open Excel

To locate and open the Excel program on your device, simply search for it in your applications or programs. Once opened, find and select the workbook or worksheet that contains the data you wish to transform for further analysis or manipulation.

Next Step

Step 2: Select the Cells with Dashes

To highlight specific cells or a range of cells for removal, simply click and drag your mouse over the data or dash you wish to remove. This action helps to select and isolate the desired area, making it easier to delete or modify the selected content.

Next Step

Step 3: Access the Replace Function

To navigate to the “Home” tab in Excel, click on “Find & Select” in the Editing section, then choose “Replace” or use the shortcut Ctrl + H on your keyboard.

Next Step

Step 4: Input Dashes in the ‘Find What’ Field

In the dialog box that appears, there will be two text box spaces: one titled ‘Find What’ and the other ‘Replace With’. In the ‘Find What’ text box, you need to input the dash symbol (” – “) that you wish to remove from your content. This symbol can be any hyphen, en-dash, or em-dash.

Next Step

Step 5: Leave the ‘Replace With’ Field Empty

To remove the dashes, leave the ‘Replace With’ box empty. This ensures that the dashes are eliminated without any replacement.

Next Step

Step 6: Click on ‘Replace All’

By inputting the desired text in the ‘Find What’ box and leaving the ‘Replace With’ box empty, selecting ‘Replace All’ removes every occurrence of the dash symbol in the designated area. This command thoroughly searches and eliminates the dash symbol across the entire selection.

Next Step

Step 7: Close the Dialog Box

Once Excel has completed replacing the dashes, simply click ‘OK’ to acknowledge and then close the ‘Find and Replace’ box to finalize the process.


In conclusion, removing dashes in Excel can greatly enhance the readability and usability of your data. By applying simple formulas or utilizing the Find and Replace function, you can quickly and efficiently eliminate dashes from your spreadsheets.

We have explored different methods like the SUBSTITUTE function, CONCATENATE function, and custom formatting to achieve this task. Each approach offers its own advantages and may be more suitable for specific situations.

Remember, when working with data, accuracy and clarity are of utmost importance. Removing dashes not only makes your spreadsheets look more professional but also allows for easier analysis and manipulation of the data.

Continue to explore the various Excel functions and features available to you, as mastering them will undoubtedly boost your productivity and efficiency in handling data. Happy Excel-ing!

Table of Contents