And if you want to count the number of times "X" or "x" shows up in a cell:

=len(a1)-len(substitute(upper(a1),"X",""))



Joe wrote:

Does anybody know how I can count the number of characters in a cell, I know

how to use the 'count' and 'counta' function to count the number of cells

used but not in a cell.

Thanks

--

Dave Peterson