ExcelBanter - How do i count character in cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do i count character in cell? (https://www.excelbanter.com/excel-discussion-misc-queries/14273-how-do-i-count-character-cell.html)

Angie

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

Marvin P. Winterbottom

=len(a1)

Bernard Liengme

=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

All times are GMT +1. The time now is 04:08 PM.