Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the number of characters created by string text
Is there a formula that will count the number of characters, and spaces
between characters, in a short paragraph created by a string text? It is acceptible if spaces cannot be counted. Thanks. Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the number of characters created by string text
You have to give an example, becuase your description is very cryptic.
Show a sample string of text, illustrate the characters that ou want the space between, and the expected result. Cheers, Jason Lepack wrote: Is there a formula that will count the number of characters, and spaces between characters, in a short paragraph created by a string text? It is acceptible if spaces cannot be counted. Thanks. Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the number of characters created by string text
One way:
=LEN(A1) will count all the characters in cell A1. =LEN(A1) - LEN(SUBSTITUTE(A1," ","")) will count all the non-space characters in A1 In article . com, wrote: Is there a formula that will count the number of characters, and spaces between characters, in a short paragraph created by a string text? It is acceptible if spaces cannot be counted. Thanks. Michael |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the number of characters created by string text
For example, if cell A1="Dogs bark in the night." and B1="But cats are
quiet.", and if I wanted the two to string I would use the formula: =A1&" "&A2 This would give the the short paragraph: Dogs bark in the night. But cats are quiet. What I need to do is count the characters in the statement, along with spaces if possible. In this case, there are 34 characters and 9 spaces if 2 are counted between the sentences. I'm hoping to find a formula that will do the count automatically. Thanks. Michael |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the number of characters created by string text
Thank you JE. I'll give it a try. Michael |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the number of characters created by string text
Thanks JE. It's exactly what I was looking for.
Michael |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the number of characters created by string text
One way:
Assume the concatenation is in C1: ="There are " & LEN(SUBSTITUTE(C1," ","")) & " characters and " & LEN(C1)-LEN(SUBSTITUTE(C1," ","")) & " spaces." In article . com, wrote: For example, if cell A1="Dogs bark in the night." and B1="But cats are quiet.", and if I wanted the two to string I would use the formula: =A1&" "&A2 This would give the the short paragraph: Dogs bark in the night. But cats are quiet. What I need to do is count the characters in the statement, along with spaces if possible. In this case, there are 34 characters and 9 spaces if 2 are counted between the sentences. I'm hoping to find a formula that will do the count automatically. Thanks. Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number times text appears in string | Excel Discussion (Misc queries) | |||
Count characters within a string | Excel Worksheet Functions | |||
LOOKUP a text string created from IF statement | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |