Text to Columns, skip *excel* columns...

Occasional Contributor

When using the Text To Columns feature is there a way to have it skip over an *Excel* column? So, in the attached pic, the numbers get moved into the 'Item 1' column, the 'Item 2' column, they skip over the 'Total 1 and 2' column and go into the 'Item 3' and 'Item 4' columns. Or is this a vba thing?


Screenshot 2022-12-17 at 12.55.35 PM.png



2 Replies


Data > Text to Columns cannot do that - it will always copy data to adjacent columns, overwriting anything that is already there.

The easiest workaround would be to place the two Total columns to the right. If you prefer, you can move the Total 1+2 column back between Item 1 and Item 3 after applying Text to columns.

Thanks. Thought that might be the case. The pic was just illustration. The actual is a lot bigger (and messier) making it difficult to move around columns.