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

microsoft excelmicrosoft-excel-2010

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?

Best Answer

This seemed to work, but is a bit involved.

  1. Enter data into a cell.
  2. Select the Text to Columns feature.
  3. Make sure Delimited is selected and choose Next.
  4. Uncheck the check next to Space (or the delimiter you want to disable)
  5. Click Finish.
Related Question