| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dot count
can I do a dot count in a cell?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dot count
=LEN(A1)-LEN(SUBSTITUTE(A1,".",""))
if you by dot mean a period -- Regards, Peo Sjoblom "nae" wrote in message ... can I do a dot count in a cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dot count
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. "nae" wrote in message ... can I do a dot count in a cell? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dot count
That's one of the autocorrect entries that I've removed (for this very reason).
Dave Thomas wrote: 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. "nae" wrote in message ... can I do a dot count in a cell? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dot count
Me also long time past.
Gord On Thu, 19 Jul 2007 17:42:52 -0500, Dave Peterson wrote: That's one of the autocorrect entries that I've removed (for this very reason). Dave Thomas wrote: 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. "nae" wrote in message ... can I do a dot count in a cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
