I have a Parts List with over 2,000 part numbers - one part number per row and all in Column B. The format of the part numbers is as follows: 9999-999-999
The software that I need to import the parts list into does not recognize the "-" (hyphen) embedded in the part number. The part number format that MUST be adhered to in the new software requires a "space" where the "-" (hyphen) is now shown.
So, the newly formatted part number should look like this: 9999 999 999
Is there a way to make this replacement for all part numbers listed in the spreadsheet at one time?