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