Paste from word to excel, into one cell.

[Guest]

Trying to paste a few lines of text from Word into a single cell in Excel and
it pastes onto several rows.

How do I make it paste into a single cell ?

thanks

 

[Guest]

Copy the text in Word.
Select the cell in Excel
Click on the formula bar and paste in the formula bar.

 

[Dave Peterson]

Saved from a previous post:

If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.

One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.

I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)
Find what: (paragraph mark under Special button)
replace with: $$$$$ (if $$$$$ doesn't appear in the table)
replace all

Same thing with Manual Line break (from under Special).

Now copy the table into Excel.

Edit|Replace
Replace what: $$$$$
Replace with: ctrl-j
replace all.

Don't forget to close the word document without saving (or hit undo as many
times as necessary).

 

[MartinW]

Hi Tony,

Just to add to Gary's post you may want to paste into Notepad
first and then copy and paste from Notepad to the formula bar.

This will get rid of all the excess baggage that word tacks on.

HTH
Martin

 

[James Silverton]

Hello, MartinW!
You wrote on Tue, 26 Sep 2006 23:27:12 +1000:

M> Just to add to Gary's post you may want to paste into
M> Notepad first and then copy and paste from Notepad to the
M> formula bar.

M> This will get rid of all the excess baggage that word tacks
M> on.

The PureText free utility: http://www.stevemiller.net/puretext/

is a faster way to deal with this since it does not require
opening other programs.

Incidentally a very wry comment, I have been using Excel for
longer than I care to admit but I had not noticed that the space
was called the "Formula Bar" I now know the annotation
appears if you look but I guess I've never bothered. I just
mentally regarded it as the "Entry Space".

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

 

[Guest]

That seems to work just fine. Thanks

Copy the text in Word.
Select the cell in Excel
Click on the formula bar and paste in the formula bar.

 

[Guest]

I wanted eaxctly the opposite.
I had been typing a while and upon completition decided to spell check
manually. then noticed this was to long accross the page.
So I tried to set the cursor behind where i want to wrap down to the next
line.
Like you would in Word.
It deleted everything and left no way to undo or redo.
I am still steaming. it was a perfect course of typing.
I just wanted it to be like a webpage RIGHT IN FRONT OF ME not so far right
that I was in the quad Z column.

and i have now been reading these forums for an hour and have found nothing
similar to tell me why what the help instructions say, don't work.

 

[Dave Peterson]

I'm not sure I understand your question.

But you can wrap text in a cell by formatting the cell:
format|cells|alignment tab|check wrap text.

You can also force a new line within the cell by hitting alt-enter.