This will select all the sheets in your Excel file. Click on the formula bar and close the bracket. Press Enter. When you are done, use the Fill Handle to fill the formula in all the cells.

Now, use the fill handle to apply the same relative formula to cells B4 to B6. To finish this section, copy and paste the formula into cell E3, and use the fill handle again.

Let’s see all these fixes in detail. 1] Remove dashes in Excel by using the Flash Fill method This is the easiest method to remove dashes from data in Excel. Flash Fill identifies the pattern ...

With cell B2 selected, I can now use the fill handle in the bottom-right corner of the cell to duplicate this relative formula to the remaining rows of details.