How to count the number of characters in a cell in Google Spreadsheet?

D

Dmitry Karmazin2014-07-23 17:34:21

Google Sheets

Dmitry Karmazin, 2014-07-23 17:34:21

If the text "dad loves mom" is written in a Google spreadsheet cell, then the result of the formula should be 15. What should the formula be?
Searched here but didn't find https://support.google.com/docs/table/25273?hl=ru
Thanks in advance.

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

E

EndUser, 2014-07-24
@dkarmazin

Do you mean =len() ?

D

Dmitry Karmazin, 2014-07-24
@dkarmazin

screenshot backup

S

Sergiy Marishchuk, 2021-04-21
@loochanin

=DLSTR(A:A)
=DLSTR(A1)
https://support.google.com/docs/answer/3094081?hl=en