Forum Discussion
Re: Stop automatic text-to-columns formatting
Excel will remember the settings during a session, but when you start Excel, there shouldn't be presets.
4 Replies
I always do the splitting a file thing first, then other comparisons later in the next process. But this way of turning it off, while awkward, works without me having to exit Excel and re-enter.
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.
