Are all entries supposed to have at least 255 characters?
=IF(LEN(A1)<255,"Truncated","Good")

LEN function tells you the length of text in a cell. You could of course
change logic to , or =.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"EllenM" wrote:

Hello,
I've exported an access table into excel. In the process, it looks like
some of the entries were truncated. How can I find all cells with 255
characters? I'd like to check each one for possible truncation. Is there a
function that will do this?

Thanks,
Ellen