Forum Discussion
Solved
Stop automatic text-to-columns formatting
This morning I was pasting text into excel and using Text-to-Columns to parse it. Later, in a different file, I was pasting other text that I did not want parsed into different columns. But excel is a...
Sometimes, Excel is too clever for its own good.
Select an empty cell.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next >.
Clear the check boxes of all delimiters.
Click Finish.
The problem should be gone (until the next time...)
The next to last reply in VBA code to reset after execution or to end command contains a macro that will reset Text to Columns.
If you copy that macro to a module in your Personal Macro Workbook PERSONAL.XLSB and assign it to a keyboard shortcut and/or Quick Access Toolbar button, you can reset it at any moment using one keystroke or mouse click.
Ah, this is the same "have it split columns with no delimiters" as before, but in a macro not manually. Makes sense.