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

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

Works beautifully!!

For future reference, please post your questions in ONE newsgroup only... I
just finished wasting my time answer this same question of yours in (one of)
the other newsgroups you posted it in.

--
Rick (MVP - Excel)


"EllenM" wrote in message
...
Works beautifully!!