How to copy a cell to another sheet having more than 255 characte.

[indra]

It is copying only first 255 character.. How to resolve this problem to copy
entire cell content

[Peo Sjoblom]

Copy from the formula bar

--
Regards,

Peo Sjoblom

(No private emails please)


"indra" <indra@discussions.microsoft.com> wrote in message
news:4B501A31-ED28-4832-AC19-F2AE8A175D4A@microsoft.com...
> It is copying only first 255 character.. How to resolve this problem to
> copy
> entire cell content

[Dave Peterson]

Copy the sheet the way you just did (ignore the warning). That way, you'll get
all the things that come with the sheet--page setup, event code...

Then go back to the original sheet, select all the cells, edit|copy and back to
the new sheet and paste over all the values (even the truncated ones).

indra wrote:
>
> It is copying only first 255 character.. How to resolve this problem to copy
> entire cell content

--

Dave Peterson