Run this short macro:

Sub findLong()
For Each r In ActiveSheet.UsedRange
If Len(r.Value) 254 Then
r.Interior.ColorIndex = 6
End If
Next
End Sub

or use Conditional Formatting to do the same function.
--
Gary''s Student - gsnu200832


"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.

Thanks,
Ellen