Function to find truncated entries?
Testing for text in A1 use =LEN(A1)
This will return the number of characters including white spaces.
Paul
"EllenM" wrote in message
...
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
|