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.
--
Chris

Do the paste directly within the formula bar
Click inside the cell's formula bar Paste (or Ctrl+V)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Chris" wrote:
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.
--
Chris

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

Chris wrote:

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.
--
Chris

--

Dave Peterson

On Nov 5, 12:20 pm, Dave Peterson wrote:
If it's only one cell's worth of data, you canpasteinto the formulabar (at the
top).

Chris wrote:

How do Ipastecopied text into only one cell of a row? When Ipastetext
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 andpasteas
an add to the text in the single cell.

Appreciate any help.
--
Chris

--

Dave Peterson

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.



Roger wrote:

On Nov 5, 12:20 pm, Dave Peterson wrote:
If it's only one cell's worth of data, you canpasteinto the formulabar (at the
top).

Chris wrote:

How do Ipastecopied text into only one cell of a row? When Ipastetext
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 andpasteas
an add to the text in the single cell.

Appreciate any help.
--
Chris

--

Dave Peterson

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

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

"Roger" wrote in message
ups.com...
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?

On Nov 5, 12:20 pm, Dave Peterson wrote:
If it's only one cell's worth of data, you canpasteinto the formulabar
(at the
top).

Chris wrote:

How do Ipastecopied text into only one cell of a row? When Ipastetext
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
andpasteas
an add to the text in the single cell.

Appreciate any help.