If the OP is pasting additional text, it doesn't sound like a Copy|paste problem
to me.

It sounds like the OP is already pasting that additional text into the existing
text in the cell--either in the formula bar or directly in the cell (if that
option is turned on).



ed wrote:

On Jul 15, 4:38 pm, Dave Peterson wrote:
Try changing the format of the cell from text to General.

Mark S. wrote:

The cell was filled with text that I want to keep. Then I copy / paste in
additional text, and all text turns to pound signs (#). Symbols go left to
right in a straight line and do not text wrap at all.
Why is this happening?

--

Dave Peterson

When you copy / Paste the target cell takes on the format of the
copied cell, including erasing your conditiona lformat.. Sop changing
the format to General won't solve the problem. Instead use Paste-
special values.

ed

--

Dave Peterson