This is the easiest method to remove dashes from data in Excel. Flash Fill identifies the pattern applied to a particular cell and then it applies it to the remaining cells.

How number formats work in Excel A cell in Excel can contain different kinds of data, which in turn can be formatted in different ways.