Hello - I have a column that has a specific word on each row that needs to be removed. I tried text to column tool, but the data consists of other words that need to stay there and it parses it out to multiple columns. The word "Shipments" can be deleted as I do not need a new column for it. Thanks in advance!
i.e.
Column as is Now | Column I need it to be |
Shipments One | One |
Shipments Five | Five |
Shipments St. Paul | St. Paul |
Shipments North Carolina | North Carolina |
Solved! Go to Solution.
Worked like a charm - Thanks!!
The text to column could work if you split to two columns on the \s delimiter. You could then simply use the select tool to remove the columns you no longer need.
Ben
Thanks, but that still breaks up the St. Paul and North Carolina
You should have the 'number of columns' set to 2, then ensure you have the 'Leave Extra in Last Field' option checked.
Ben
Ah, yes... That did work. I had it set to 3 columns. Thanks!!