Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, …

This function only works with text (not numbers) as input and returns a logical value, i.e. TRUE or FALSE, as output. If numbers are used as input, convert them to text using the TEXT function.

FIND () Position of fragment in text Returns the position (Number) of a value in a text fragment, or zero (0) if not found. Note: The search is case-sensitive: upper- and lower-case letters are …

It's recommended to use a function such as IFERROR to check for cases when there aren't matches to the search. Use FIND for standard character sets, and FINDB for double-byte …

This function only works with text (not numbers) as input and returns text as output. If a number is desired as the output, try using the VALUE function in conjunction with this function.

Google Sheets function list Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create formulas that manipulate data and …

It's recommended to use a function such as IFERROR to check for cases when there aren't matches to the search. See Also SUBSTITUTE: Replaces existing text with new text in a …

This function returns text as the output. If a number is desired, try using the VALUE function in conjunction with this function. See Also TEXT: Converts a number into text according to a …

It's recommended to use a function such as IFERROR to check for cases when there aren't matches to the search. You can use the wildcard characters: question mark (?) and asterisk …

Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, …