dot count

[nae]

can I do a dot count in a cell?

 

[Peo Sjoblom]

=LEN(A1)-LEN(SUBSTITUTE(A1,".",""))

if you by dot mean a period

 

[Dave Thomas]

Be very careful with dots (periods) in Excel. If you type in "." (1 dot),
you get 1 dot. If you type in ".." (2 dots) you get 2 dots. If you type in
"..." (3 dots) you get ellipsis (...), not 3 dots. If you type in "...." (4
dots), you get ellipsis (...) and 1 dot. If you type in "....." (5 dots) you
get ellipsis (...) and 2 dots. If you type in "......" (6 dots), you get
ellipsis (...) and ellipsis (...). If you type in "......." (7 dots), you
get ellipsis (...), ellipsis(...) and 1 dot. Etc.

A dot is code 46, ellipsis is code 133. If you have a cell filled with dots
beside a cell filled with ellipses, you will see the spacing between the
dots and the ellipses is uniform, but careful inspection will reveal that
cells look different.There is a slightly wider space following the
ellipsis.This space is wider than the space between dots.

 

[Dave Peterson]

That's one of the autocorrect entries that I've removed (for this very reason).

 

[Gord Dibben]

Me also long time past.

Gord

That's one of the autocorrect entries that I've removed (for this very reason).