| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find no.of characters in a cell?
How to find no.of characters in a cell?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find no.of characters in a cell?
=LEN(A1)
-- Brevity is the soul of wit. "great whole sale club limited kolkatta" wrote: How to find no.of characters in a cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find no.of characters in a cell?
If you're looking for an *actual character* count, and don't want to count
spaces, Try this: =LEN(SUBSTITUTE(A1," ","")) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "great whole sale club limited kolkatta" <great whole sale club limited kolkatta @discussions.microsoft.com wrote in message ... How to find no.of characters in a cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of characters in a cell | Excel Discussion (Misc queries) | |||
| How to set number of characters within a cell in Excel 2003? | Excel Worksheet Functions | |||
| Display text 1024 characters in a cell | Excel Worksheet Functions | |||
| How can I increase the number of printable characters in a cell? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
