Character count for cells
Posted by DC on February 04, 2002 3:04 PM
Is there a way to count the number of characters in a cell. I have a lot of data in each cell and I need to know which cells go over a certain number of characters.
is this possible?
Posted by faster on February 04, 2002 3:07 PM
In a blank cell insert this formula:
= LEN(cell)
where cell = the cell you want to count characters
Posted by anno on February 04, 2002 3:08 PM
Posted by anno on February 04, 2002 3:12 PM
you certainly live up to your name, faster. 58 seconds faster, in fact. ; )
Posted by faster on February 04, 2002 3:25 PM
Thanks. Faster doen't always = better though. 8Þ
