| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i count character in cell?
Hi,
I need to count the total of characters in a cell. How do i count character in cell? For example: I have in the cell A1, the text ¨Me gusta mucho la tecnologia¨ the sum of character is 28, and i want this number in cell B1. Thanks Angie |
|
#2
|
|||
|
|||
|
=len(a1)
|
|
#3
|
|||
|
|||
|
=LEN(A1)
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Angie" wrote in message ... Hi, I need to count the total of characters in a cell. How do i count character in cell? For example: I have in the cell A1, the text ¨Me gusta mucho la tecnologia¨ the sum of character is 28, and i want this number in cell B1. Thanks Angie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you perform a character count per cell with numbers? | Excel Discussion (Misc queries) | |||
| Searching a cell for a certain character. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| want if cell containts text, then increase count by one | Excel Worksheet Functions | |||
| how to count the nr of occurrences of a text string in a cell rang | Excel Worksheet Functions | |||
Linear Mode
