Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
mine is splitting url's on the colon... in every spreadsheet I use! –  boomhauer Jan 18 at 19:54
add comment

2 Answers 2

Wouldn't CTRL Z for undo be a faster way to revert it?

share|improve this answer
    
Undo reverts not only the implicit split, but also the explicit paste itself. I want the paste, just not the split. –  Leigh Riffel May 21 '12 at 18:58
add comment
up vote 6 down vote accepted

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.
share|improve this answer
    
Don't forget to mark your answer as the solution @leigh-riffel. It helps the community. –  evan.bovie May 21 '12 at 20:05
    
this worked. so it appears the last text-to-columns operation is used for all future pasting. –  boomhauer Jan 18 at 19:55
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.