Specific steps:

Select all table data,

Copy to a blank notepad.

Press Ctrl+H to find the replacement shortcut key.

Find content, fill in'

Click Replace All.

Then select all the data and copy it into a blank table in Excel.

Method 2: Use Excel data sorting function.

Specific steps:

Select all data in this column.

Click the Data tab.

Click "detach"

Click "Next"

Separator, select Other, and fill in'

Then click Next.