I have formatted my column for word-wrap but when pasting in text (from
Word), the word-wrap is ignored and the text is pasted in one long line, as
if over-riding the formatting of the cell. Is there a way to 'lock' word
wrap so that it cannot be over-ridden?

You can click in the formula bar (or press F2) and do the paste there
(ctrl/v) -- that should leave the cell formatting intact.
Bob Umlas
Excel MVP

"jan@longcroft" wrote:

I have formatted my column for word-wrap but when pasting in text (from
Word), the word-wrap is ignored and the text is pasted in one long line, as
if over-riding the formatting of the cell. Is there a way to 'lock' word
wrap so that it cannot be over-ridden?

Is there a limit on the amount of text that is pasted into a cell? All of
the pasted text is not showing up no matter how bit I resize the cell and
wrap the text.
--
wagnew


"Bob Umlas, Excel MVP" wrote:

You can click in the formula bar (or press F2) and do the paste there
(ctrl/v) -- that should leave the cell formatting intact.
Bob Umlas
Excel MVP

"jan@longcroft" wrote:

I have formatted my column for word-wrap but when pasting in text (from
Word), the word-wrap is ignored and the text is pasted in one long line, as
if over-riding the formatting of the cell. Is there a way to 'lock' word
wrap so that it cannot be over-ridden?

Exzcel help on specifications state you can enter 32767 characters in a cell
but only 1024 of these will display or print.

You can add a linefeed every 100 characters........Alt + ENTER...........to
increase the 1024 limit.


Gord Dibben MS Excel MVP


On Thu, 28 Aug 2008 07:26:01 -0700, wagnew wrote:

Is there a limit on the amount of text that is pasted into a cell? All of
the pasted text is not showing up no matter how bit I resize the cell and
wrap the text.

Thanks for the reply - since I posted my question, I have now seen all the
answers about the limitation of characters
--
wagnew


"Gord Dibben" wrote:

Exzcel help on specifications state you can enter 32767 characters in a cell
but only 1024 of these will display or print.

You can add a linefeed every 100 characters........Alt + ENTER...........to
increase the 1024 limit.


Gord Dibben MS Excel MVP


On Thu, 28 Aug 2008 07:26:01 -0700, wagnew wrote:

Is there a limit on the amount of text that is pasted into a cell? All of
the pasted text is not showing up no matter how bit I resize the cell and
wrap the text.