I have a column of SKUs that have been broken up in one system by hyphens, but are uninterrupted numbers in another. I want to remove the dashes throughout the column so that they match the second system. Is there a simple way to do this?
Column A
12-455
11-555
43-908
Should read:
12455
11555
43908
Column A
12-455
11-555
43-908
Should read:
12455
11555
43908