Removing Characters from Cell
There is an Excel file that teaches how to perform the Removing Characters from Cell operation.
Excel Professional Removing Characters From Cell
This workbook removes specific characters from cell contents using VBA, with a 5-row data area and cell selection instructions.
Hope it is useful.