I recently used the Text to Columns feature in Excel to split a column of data into multiple columns based on the space character. Now when I paste text into Excel it automatically splits it into multiple columns without using the Text to Columns feature. Is there a way to revert this functionality back to normal?
Excel – Pasting text into Excel without splitting on spaces (or other delimiter)
microsoft excelmicrosoft-excel-2010
Best Answer
This seemed to work, but is a bit involved.