Find truncated cells
 

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

Find truncated cells
 

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

Find truncated cells
 

Works beautifully!!

Find truncated cells
 

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!!