| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can you count the number of letters (inc spaces) in a single sell
I have a spreedsheet which has 3000 rows. Each cell has a different amount
of words in it... ie ABC Learning Centre Ferrymead. Is it possible to count the number of characters (letters) including spaces in each cell??? (please note each cell has a different number of letters in it)... or do I have to do this manually? none of the help options seem to help me... Thanks |
|
#2
|
|||
|
|||
|
use the formula =len() -- PF Wannabe ------------------------------------------------------------------------ PF Wannabe's Profile: http://www.excelforum.com/member.php...o&userid=25798 View this thread: http://www.excelforum.com/showthread...hreadid=392034 |
|
#3
|
|||
|
|||
|
"greenstone" wrote in message
I have a spreedsheet which has 3000 rows. Each cell has a different amount of words in it... ie ABC Learning Centre Ferrymead. Is it possible to count the number of characters (letters) including spaces in each cell??? (please note each cell has a different number of letters in it)... or do I have to do this manually? none of the help options seem to help me... Thanks Just out of pure curiosity, can I ask why you need to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the number of alpha occurences in a range? | Excel Worksheet Functions | |||
| How do i count the number of conditional formatted cells? | Excel Discussion (Misc queries) | |||
| count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Linear Mode
