| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting letters in a cell
My formula is =LEN(A1) and copied down.
Is there a variation of this formula to count just the letters in each cell without counting the spaces between words ? Thanks for the reply. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting letters in a cell
=LEN(SUBSTITUTE(A1," ",""))
-- David Biddulph "Learning Excel" wrote in message ... My formula is =LEN(A1) and copied down. Is there a variation of this formula to count just the letters in each cell without counting the spaces between words ? Thanks for the reply. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting letters in a cell
Thanks a lot David Biddulph.
-- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "David Biddulph" wrote: =LEN(SUBSTITUTE(A1," ","")) -- David Biddulph "Learning Excel" wrote in message ... My formula is =LEN(A1) and copied down. Is there a variation of this formula to count just the letters in each cell without counting the spaces between words ? Thanks for the reply. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting letters in a cell
Do you happen to have a formula to count WORDS in a cell ?
-- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "Learning Excel" wrote: Thanks a lot David Biddulph. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "David Biddulph" wrote: =LEN(SUBSTITUTE(A1," ","")) -- David Biddulph "Learning Excel" wrote in message ... My formula is =LEN(A1) and copied down. Is there a variation of this formula to count just the letters in each cell without counting the spaces between words ? Thanks for the reply. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting letters in a cell
Depends how you want to define words, but if you want to count spaces and
add one (unless the cell is empty), you could try: =IF(LEN(A1)=0,0,LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1) If you had multiple spaces in one place, that would get it confused, of course. -- David Biddulph "Learning Excel" wrote in message ... Do you happen to have a formula to count WORDS in a cell ? "Learning Excel" wrote: Thanks a lot David Biddulph. "David Biddulph" wrote: =LEN(SUBSTITUTE(A1," ","")) -- David Biddulph "Learning Excel" wrote in message ... My formula is =LEN(A1) and copied down. Is there a variation of this formula to count just the letters in each cell without counting the spaces between words ? Thanks for the reply. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting letters in a cell
Another one that will count the number of "words" separated by spaces:
=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+(TRIM(A1)<"") Learning Excel wrote: Do you happen to have a formula to count WORDS in a cell ? -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "Learning Excel" wrote: Thanks a lot David Biddulph. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "David Biddulph" wrote: =LEN(SUBSTITUTE(A1," ","")) -- David Biddulph "Learning Excel" wrote in message ... My formula is =LEN(A1) and copied down. Is there a variation of this formula to count just the letters in each cell without counting the spaces between words ? Thanks for the reply. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting letters in a cell
Thanks David. Thanks Dave.
Both formulas work for me, appreciate your time. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "Dave Peterson" wrote: Another one that will count the number of "words" separated by spaces: =LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+(TRIM(A1)<"") Learning Excel wrote: Do you happen to have a formula to count WORDS in a cell ? -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "Learning Excel" wrote: Thanks a lot David Biddulph. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "David Biddulph" wrote: =LEN(SUBSTITUTE(A1," ","")) -- David Biddulph "Learning Excel" wrote in message ... My formula is =LEN(A1) and copied down. Is there a variation of this formula to count just the letters in each cell without counting the spaces between words ? Thanks for the reply. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting letters. | Excel Worksheet Functions | |||
| Counting letters and symbols | Excel Worksheet Functions | |||
| Counting Letters | Excel Worksheet Functions | |||
| Counting the number of letters in a cell | Excel Discussion (Misc queries) | |||
| Counting Letters | Excel Worksheet Functions | |||
Linear Mode
