paste copied text to only one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
If it's only one cell's worth of data, you can paste into the formulabar (at the
top).
 
If it's only one cell's worth of data, you canpasteinto the formulabar (at the
top).
Click to expand...

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
 
If you select the cell, then click in the formula bar, you should be able to
paste in that formula bar.
 
Now you know why most experts in this group recommend avoiding merged cells
like the plague.
 
Back
Top