Supported text functions

CHAR

Returns the character specified by a number. Char values follow the ASCII value mapping.

For more information, refer to the Google Sheets documentation.

CHAR(number)

Example

CHAR(10)

CONCAT

Concatenates (combines) any number of strings into a single string.

For more information, refer to the Google Sheets documentation.

CONCAT(string1, string2, ...)

Example

CONCAT("Hello", " ", "World")       # Results in "Hello World"

CONCATENATE

Concatenates (combines) any number of strings into a single string. Alias for CONCAT.

For more information, refer to the Google Sheets documentation.

CONCATENATE(string1, string2, ...)

Example

CONCATENATE("Hello", " ", "World")

CLEAN

Returns text with the non-printable ASCII characters removed. Unicode characters that aren’t in ASCII are not removed.

For more information, refer to the Google Sheets documentation.

CLEAN(text)

Example

CLEAN("Hello"&CHAR(31))

EXACT

Tests whether two text strings are exactly the same. Returns TRUE if the strings match, FALSE otherwise. This function is case-sensitive.

For more information, refer to the Google Sheets documentation.

EXACT(string1, string2)

Example

EXACT("hello", "Hello")

FIND

Returns the position of one string inside another.

For more information, refer to the Google Sheets documentation.

FIND(find_text, within_text)

Example

FIND("n", "JustAsk")

Limitations

Unlike Google Sheets or Excel, JustAsk’s FIND does not accept a third argument for start number/index.

LEFT

Returns the specified number of characters from the start of a text string.

For more information, refer to the Google Sheets documentation.

LEFT(text, [num_chars])

Example

LEFT("Hello", 3)

LEN

Returns the length (number of characters) of a string.

For more information, refer to the Google Sheets documentation.

LEN(text)

Example

LEN("Hello")

LOWER

Converts text to lowercase.

For more information, refer to the Google Sheets documentation.

LOWER(text)

Example

LOWER("Hello")

MID

Returns a specific number of characters from a text string starting at the specified position.

For more information, refer to the Google Sheets documentation.

MID(text, start_num, num_chars)

Example

MID("Hello", 2, 3)

PROPER

Capitalizes the first letter of each word in a text string.

For more information, refer to the Google Sheets documentation.

PROPER(text)

Example

PROPER("hello world")       # Results in "Hello World"

REPLACE

Replaces characters in a string with new text.

For more information, refer to the Google Sheets documentation.

REPLACE(old_text, start_num, num_chars, new_text)

Example

REPLACE("Hello", 2, 3, "i")

RIGHT

Returns the specified number of characters from the end of a text string.

For more information, refer to the Google Sheets documentation.

RIGHT(text, [num_chars])

Example

RIGHT("Hello", 3)

SEARCH

Finds one text value within another, ignoring case.

For more information, refer to the Google Sheets documentation.

SEARCH(find_text, within_text)

Example

SEARCH("blobs", "The happiest place on earth is Blobs R Us")

Limitations

Unlike Google Sheets or Excel, JustAsk’s SEARCH does not accept a third argument for start number/index.

SUBSTITUTE

Substitutes new text for old text in a string.

For more information, refer to the Google Sheets documentation.

SUBSTITUTE(text, old_text, new_text)

Example

SUBSTITUTE("Hello World", "World", "JustAsk")

Unlike Google Sheets or Excel, JustAsk’s SUBSTITUTE does not accept a fourth argument for instance_num.

TRIM

Removes leading, trailing, and repeated spaces from text, leaving only single spaces between words.

For more information, refer to the Google Sheets documentation.

TRIM(text)

Example

TRIM("  Hello   World  ")

T

Returns string arguments as text.

For more information, refer to the Google Sheets documentation.

T(value)

Example

T(A1)
T("2025-01-01")

TEXT

Converts a number into text according to a specified format.

For more information, refer to the Google Sheets documentation.

TEXT(value, "format")

Example

TEXT(1.23,"$0.00")
TEXT(DATE(1969,7,20),"yyyy-MM")

UPPER

Converts text to uppercase.

For more information, refer to the Google Sheets documentation.

UPPER(text)

Example

UPPER("hello")