FIND

Locate the position of a character or substring in text.

Intermediate

— views

Syntax

=FIND(find_text, within_text, [start_num])

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
TEXT	Format numbers, dates, or times as text using custom formatting.	=TEXT(value, format_text)
SUBSTITUTE	Replace specific text within a string.	=SUBSTITUTE(text, old_text, new_text, [instance_num])