How to remove dashes in excel


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