After I use the text to column functionality in excel, I cannot stop it. I noticed this error in Excel 2003 and up.
Imagine I copy some large text, paste it into a sheet, and run text to column, to separate it at every
I keep working, and now I want to paste a different text for a different reason. I do not want it separated by every space, but it still is. So far I only found two solutions:
- Closing excel completely (every workbook, not just the misbehaving one) and reopening the workbook
- Pasting the content into a table in a Word document, and copy-pasting this table to excel
Both are overly complicated, is there a better way to stop text to column?
This is not about the import wizard.