In this tutorial, I showed you four different ways to quickly remove dashes from a data set in Excel. If you do this once in a while and want to get this done quickly, you can use the Flash Fill …

May 7, 2025 · So, now you know how to remove dashes in Excel using various methods like a formula, the Format Cell tool, the Power Query tool, Excel VBA, and Office Scripts. Depending …

Learn how to remove dashes from data in Excel using simple methods such as Find and Replace and text formulas.

Jun 8, 2024 · To remove dash lines in Excel, you can use the SUBSTITUTE function to replace the dash lines with an empty string. Here’s a generic formula: =SUBSTITUTE (A1, “-“, “”)

Dec 6, 2024 · Here are three easy ways for you to learn how to remove dashes in Excel: the SUBSTITUTE formula, Flash Fill, and the Find and Replace formula. Read on as I show you …

Oct 15, 2021 · Here is the formula you would use: =SUBSTITUTE (A2,”-“,””) Let’s better understand what this formula is trying to do: A2 is for the cell in which you want to remove the …

Aug 30, 2024 · With these easy (and efficient) tricks, you’re all set to steer your Excel spreadsheets clear of any unwanted dashes. Let me tell you – using these methods you can …

Jun 18, 2024 · Use the SUBSTITUTE function if you prefer using formulas. The syntax is =SUBSTITUTE(A1, "-", ""). Use conditional formatting to highlight cells with dashes before you …

Dec 21, 2022 · We can use this nifty function to remove dashes in a dataset. What we’ll do is replace the dashes (-) with a null or blank value. We will be using the following data for our …

You can use an array formula combining REPLACE and SEARCH to remove all dashes. You can enter this formula as an array formula with Ctrl+Shift+Enter (in older Excel versions) or directly …