I want to remove the names and leave the code on this column.
Select the column.
On the Data tab of the ribbon, click Text to Columns.
In Step 1, select Fixed, then click Next >.
In Step 2, drag a vertical line to immediately after the codes, and remove the other lines by double-clicking on them. Then click Next >.
In Step 3, click on the second column, then select 'Do not import column (skip).