Delete one by one

Method 2

Alt+F

Click the second replacement.

Click Special Format.

Select the one you want to replace.

Replace with blank (replace with this column and write nothing)

Direct point all replacement

What do you want to replace?

It's all empty.