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 need to take content from an Excel spreadsheet (see below for example), that takes up about 20 cells, and paste it into one cell. I've tried pasting it into a word or notepad documents, and then pasting it back, but it still tries to import it back in tab delimited format (taking up the 20 cells again).

I need to turn this:

Title:  Farmers Eating
Year:   1980
Categories: Bulls
    Prairies
    Shepherds
    Farmers
Geographical Area:  Midwest, South

Into this:

Title:Farmers Eating Year:1980 Categories:Bulls Prairies Shepherds Farmers Geographical Area:Midwest, South

So that it fits back into one cell.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

I assume that, when you paste into Microsoft Word, you paste as unformatted text only.  If so, it seems that the next step is to fire up a “Find and Replace” window (available by keyboard shortcut Ctrl+H) and replace all occurrences of ^p (the symbol for an end-of-paragraph) with spaces.  (Then copy and paste back into Excel.)

share|improve this answer
    
Thank you!!!!!! –  Unsure How to Pose my Question Apr 2 '13 at 20:46
    
+1. Depending upon the formating that your fields come with, you may have to replace the delimiting characters (e.g. tabs) as well. –  dav Apr 2 '13 at 20:54
    
Very True!!! Thank you as well!!! –  Unsure How to Pose my Question Apr 2 '13 at 21:04

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.