| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to count the no. of characters in a cell in Excel?
In order to create Tweets in Excel, I wanted to know if you could count the
characters/spaces in a cell. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is it possible to count the no. of characters in a cell in Excel?
Hi,
To count characters excluding spaces =LEN(SUBSTITUTE(A1," ","")) to count spaces =LEN(A1)-LEN(SUBSTITUTE(A1," ","")) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "karbrown12" wrote: In order to create Tweets in Excel, I wanted to know if you could count the characters/spaces in a cell. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is it possible to count the no. of characters in a cell in Excel?
=LEN(A1)
"karbrown12" wrote: In order to create Tweets in Excel, I wanted to know if you could count the characters/spaces in a cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the Characters in a cell | Excel Discussion (Misc queries) | |||
| Count Characters in A Cell | Excel Discussion (Misc queries) | |||
| Count Characters in a cell | Excel Discussion (Misc queries) | |||
| Can I auto count the # of characters in an excel cell? | Excel Discussion (Misc queries) | |||
| A formula to count characters in an Excel cell? | Excel Worksheet Functions | |||
Linear Mode
