Get error message about copying cells with more than 255 characte.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mghntlh - 26 Mar 2008 22:04 GMT

I am trying to copy two sheets from one file into a new file. I receive the
following message: "The sheet you are copying has cells that contain more
than 255 characters. When you copy the entire sheet, only the first 255
characters in each cell are copied. To copy all of the characters, copy the
cells to a new sheet instead of copying the entire sheet." I do not believe
I have cells with more than 255 characters in them. My question is, is there
any way to find the cell(s) that supposedly has the more than 255 characters,
and if not, how do I eliminate this error message.

Reply to this Message

NoodNutt - 27 Mar 2008 13:03 GMT

G'day

It's always nice to include your name when requesting assistance, makes it
easier when replying.

You say "You Don't believe" you have 255 character Cells.

Did you create the workbook, also, are you solely responsible for inputting
data, if not then you may very well have something of that size.

One thing you have to keep in mind is that every space you have in between
words counts as a character.

Try deleting all the surrounding unused columns & rows keeping only the area
you actually work within.

Change the view of the cells to display formulas so you can identify if any
are exceptionally long.

HTH
Mark

Reply to this Message

Gord Dibben - 28 Mar 2008 01:00 GMT

To eliminate the error message, copy all cells, not the entire worksheet.

To find cells with more than 255 characters you can use helper columns and enter

=LEN(cellref)

>I am trying to copy two sheets from one file into a new file. I receive the
>following message: "The sheet you are copying has cells that contain more
[quoted text clipped - 4 lines]
>any way to find the cell(s) that supposedly has the more than 255 characters,
>and if not, how do I eliminate this error message.

Reply to this Message