Forum Discussion
eliminating hyphen or dashes from a table of numbers
As an example of a string of numbers in a column they have 11 digits separated by 3 dashes. Example 00563-0125-01 I want to get rid of the dashes to leave a format like 00536012501 and the zero ...
You can use Power Query to also remove all the dash
1. Format the data in Excel Table
2. Select From Table/Range in Data tab
3. Click on Replace Values in the Home tab
4. Type in - in the Value To Find box
5. Click OK. There you have it in the caption below
Finally, Select Close and Load to load the result back to Excel