Pasting text into Excel without splitting on spaces (or other delimiter)?

Question

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?

Answer 1

Go to File > Options > Advanced > Cut, Copy, Paste section.

Review the settings there.

Check the settings under Use Smart Cut and Paste. You might want to just uncheck this box altogether and see if that fixes it.