@thetraininglady - There is no need for using another workbook, copy pasting, etc...
In the last window of the Txt to column wizard, you can select the columns you do not wish to import.
So there will only be one left which will replace the original without disturbing the rest

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post