LEN

Count the number of characters in a text string.

Beginner

— views

Syntax

=LEN(text)

Function	Use Case	Syntax
CLEAN	Remove non-printable characters from imported or messy text.	=CLEAN(text)

Function	Use Case	Syntax
TEXT	Format numbers, dates, or times as text using custom formatting.	=TEXT(value, format_text)
FIND	Locate the position of a character or substring in text.	=FIND(find_text, within_text, [start_num])
SUBSTITUTE	Replace specific text within a string.	=SUBSTITUTE(text, old_text, new_text, [instance_num])