Oct 17 2020
I want to remove the names and leave the code on this column.
Oct 19 2020
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).