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

[mghntlh]

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.

 

[NoodNutt]

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

 

[Gord Dibben]

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)