Title: Theory / Unimportant / CS / Softw / Website / Google / Sheets / Text
On every note of this deck, unless a note says otherwise:
Page: https://support.google.com/docs/table/25273?hl=en
Language: Sheets
Context: Text

Instruction: ARABIC(roman_numeral)
Returns: Computes the value of a Roman numeral. Learn more

Instruction: ASC(text)
Returns: Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged. Learn more.

Instruction: CHAR(table_number)
Returns: Convert a number into a character according to the current Unicode table. Learn more

Instruction: CLEAN(text)
Returns: Returns the text with the non-printable ASCII characters removed. Learn more

Instruction: CODE(string)
Returns: Returns the numeric Unicode map value of the first character in the string provided. Learn more

Instruction: CONCATENATE(string1, [string2, ...])
Returns: Appends strings to one another. Learn more

Instruction: DOLLAR(number, [number_of_places])
Returns: Formats a number into the locale-specific currency format. Learn more

Instruction: EXACT(string1, string2)
Returns: Tests whether two strings are identical. Learn more

Instruction: FIND(search_for, text_to_search, [starting_at])
Returns: Returns the position at which a string is first found within text. Learn more

Instruction: FINDB(search_for, text_to_search, [starting_at])
Returns: Returns the position at which a string is first found within text counting each double-character as 2. Learn more

Instruction: FIXED(number, [number_of_places], [suppress_separator])
Returns: Formats a number with a fixed number of decimal places. Learn more

Instruction: JOIN(delimiter, value_or_array1, [value_or_array2, ...])
Returns: Concatenates the elements of one or more one-dimensional arrays using a specified delimiter. Learn more

Instruction: LEFT(string, [number_of_characters])
Returns: Returns a substring from the beginning of a specified string. Learn more

Instruction: LEFTB(string, num_of_bytes)
Returns: Returns the left portion of a string up to a certain number of bytes. Learn more.

Instruction: LEN(text)
Returns: Returns the length of a string. Learn more

Instruction: LENB(string)
Returns: Returns the length of a string in bytes." Learn more.

Instruction: LOWER(text)
Returns: Converts a specified string to lowercase. Learn more

Instruction: MID(string, starting_at, extract_length)
Returns: Returns a segment of a string. Learn more

Instruction: MIDB(string)
Returns: Returns a section of a string starting at a given character and up to a specified number of bytes. Learn more.

Instruction: PROPER(text_to_capitalize)
Returns: Capitalizes each word in a specified string. Learn more

Instruction: REGEXEXTRACT(text, regular_expression)
Returns: Extracts matching substrings according to a regular expression. Learn more

Instruction: REGEXMATCH(text, regular_expression)
Returns: Whether a piece of text matches a regular expression. Learn more

Instruction: REGEXREPLACE(text, regular_expression, replacement)
Returns: Replaces part of a text string with a different text string using regular expressions. Learn more

Instruction: REPLACE(text, position, length, new_text)
Returns: Replaces part of a text string with a different text string. Learn more

Instruction: REPLACEB(text, position, num_bytes, new_text)
Returns: Replaces part of a text string, based on a number of bytes, with a different text string. Learn more.

Instruction: REPT(text_to_repeat, number_of_repetitions)
Returns: Returns specified text repeated a number of times. Learn more

Instruction: RIGHT(string, [number_of_characters])
Returns: Returns a substring from the end of a specified string. Learn more

Instruction: RIGHTB(string, num_of_bytes)
Returns: Returns the right portion of a string up to a certain number of bytes. Learn more.

Instruction: ROMAN(number, [rule_relaxation])
Returns: Formats a number in Roman numerals. Learn more

Instruction: SEARCH(search_for, text_to_search, [starting_at])
Returns: Returns the position at which a string is first found within text. Learn more

Instruction: SEARCHB(search_for, text_to_search, [starting_at])
Returns: Returns the position at which a string is first found within text counting each double-character as 2. Learn more

Instruction: SPLIT(text, delimiter, [split_by_each], [remove_empty_text])
Returns: Divides text around a specified character or string, and puts each fragment into a separate cell in the row. Learn more

Instruction: SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])
Returns: Replaces existing text with new text in a string. Learn more

Instruction: T(value)
Returns: Returns string arguments as text. Learn more

Instruction: TEXT(number, format)
Returns: Converts a number into text according to a specified format. Learn more

Instruction: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
Returns: Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts. Learn more.

Instruction: TRIM(text)
Returns: Removes leading and trailing spaces in a specified string. Learn more

Instruction: UNICHAR(number)
Returns: Returns the Unicode character for a number. Learn more.

Instruction: UNICODE(text)
Returns: Returns the decimal Unicode value of the first character of the text. Learn more.

Instruction: UPPER(text)
Returns: Converts a specified string to uppercase. Learn more

Instruction: VALUE(text)
Returns: Converts a string in any of the date, time or number formats that Google Sheets understands into a number. Learn more