| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Characters in A Cell
I have a text string in a cell and need to count the number of characters in
it. Is there a formula for it? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Characters in A Cell
Use =Len(cell ref)
Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Daren" wrote in message ... I have a text string in a cell and need to count the number of characters in it. Is there a formula for it? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Characters in A Cell
=LEN(A1)
"Daren" wrote in message ... I have a text string in a cell and need to count the number of characters in it. Is there a formula for it? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Characters in A Cell
Thanks
"Bob Flanagan" wrote: Use =Len(cell ref) Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Daren" wrote in message ... I have a text string in a cell and need to count the number of characters in it. Is there a formula for it? Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Characters in A Cell
Thanks
"Gaurav" wrote: =LEN(A1) "Daren" wrote in message ... I have a text string in a cell and need to count the number of characters in it. Is there a formula for it? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Characters in a cell | Excel Discussion (Misc queries) | |||
| Count consecutive characters within a cell | Excel Discussion (Misc queries) | |||
| Count Characters with space in a cell | Excel Discussion (Misc queries) | |||
| count of tab characters in a single cell | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
