TEXT

Format numbers, dates, or times as text using custom formatting.

Intermediate

— views

Syntax

=TEXT(value, format_text)

Function	Use Case	Syntax
LEN	Count the number of characters in a text string.	=LEN(text)
CLEAN	Remove non-printable characters from imported or messy text.	=CLEAN(text)

Function	Use Case	Syntax
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])