Below are the steps to use find and replace to remove dashes in Excel:
- Select the dataset from which you want to remove the dashes.
- Hold the Control key and then press the H key. ...
- In the 'Find what' field, type the dash symbol (-)
- Leave the 'Replace with' field empty.
- Click on Replace All.