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 automatically separating it. It is messing up my file formatting and forcing me to manually recombine the text into a single column. I can't find anywhere in the options that will stop this from happening. Any suggestions? Text-to-Columns should not be an automatic function.
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.
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.
@Hans Vogelaar Thanks so much for your answer! This has been a frustration for me for years! FYI, it would not let me even open the Text to Columns dialog with a blank cell selected, but it worked fine with a populated cell selected. Thanks so much!
Your solution started to work(!thanks) but I no longer can remove unwanted delimiting bars. As soon as I select 'space' as a delimiter it separates first and last names into separate columns.
It doesn't have to be space, you can set up whatever delimiter you want, just set it to something that isn't going to come up in your data. "|" is popular, or "\" or "%".
