paste copied text to only one cell

[Guest]

How do I paste copied text into only one cell of a row? When I paste text
either from a sentence in WORD or from one cell of a table in WORD, the text
ends up in multiple rows of one column. Which I then must copy and paste as
an add to the text in the single cell.

Appreciate any help.

 

[Dave Peterson]

If it's only one cell's worth of data, you can paste into the formulabar (at the
top).

 

[Roger]

If it's only one cell's worth of data, you canpasteinto the formulabar (at the
top).

Related to this is if the 'source' cell is in a 'merged' format
combining a number of cells, but the 'target' cell needs to be just
one cell, the paste special command will over write cells adjacent to
the target cell.
How is it possible to prevent this from occurring either in a macro or
in a manual operation?

Roger

 

[Dave Peterson]

If you select the cell, then click in the formula bar, you should be able to
paste in that formula bar.

 

[David Biddulph]

Now you know why most experts in this group recommend avoiding merged cells
like the plague.