ARABIC
ARABIC(roman_numeral)
Computes the value of a Roman numeral. Learn more
Apri schedaFunzioni Google Sheets
Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.
Digita almeno 2 lettere per vedere i suggerimenti.
ASC
ASC(text)
Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged. Learn more.
Apri schedaCHAR
CHAR(table_number)
Convert a number into a character according to the current Unicode table. Learn more
Apri schedaCLEAN
CLEAN(text)
Returns the text with the non-printable ASCII characters removed. Learn more
Apri schedaCODE
CODE(string)
Returns the numeric Unicode map value of the first character in the string provided. Learn more
Apri schedaCONCATENATE
CONCATENATE(string1, [string2, ...])
Appends strings to one another. Learn more
Apri schedaDOLLAR
DOLLAR(number, [number_of_places])
Formats a number into the locale-specific currency format. Learn more
Apri schedaEXACT
EXACT(string1, string2)
Tests whether two strings are identical. Learn more
Apri schedaFIND
FIND(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text. Learn more
Apri schedaFINDB
FINDB(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text counting each double-character as 2. Learn more
Apri schedaFIXED
FIXED(number, [number_of_places], [suppress_separator])
Formats a number with a fixed number of decimal places. Learn more
Apri schedaJOIN
JOIN(delimiter, value_or_array1, [value_or_array2, ...])
Concatenates the elements of one or more one-dimensional arrays using a specified delimiter. Learn more
Apri schedaLEFT
LEFT(string, [number_of_characters])
Returns a substring from the beginning of a specified string. Learn more
Apri schedaLEFTB
LEFTB(string, num_of_bytes)
Returns the left portion of a string up to a certain number of bytes. Learn more.
Apri schedaLEN
LEN(text)
Returns the length of a string. Learn more
Apri schedaLENB
LENB(string)
Returns the length of a string in bytes." Learn more.
Apri schedaLOWER
LOWER(text)
Converts a specified string to lowercase. Learn more
Apri schedaMID
MID(string, starting_at, extract_length)
Returns a segment of a string. Learn more
Apri schedaMIDB
MIDB(string)
Returns a section of a string starting at a given character and up to a specified number of bytes. Learn more.
Apri schedaPROPER
PROPER(text_to_capitalize)
Capitalizes each word in a specified string. Learn more
Apri schedaREGEXEXTRACT
REGEXEXTRACT(text, regular_expression)
Extracts matching substrings according to a regular expression. Learn more
Apri schedaREGEXMATCH
REGEXMATCH(text, regular_expression)
Whether a piece of text matches a regular expression. Learn more
Apri schedaREGEXREPLACE
REGEXREPLACE(text, regular_expression, replacement)
Replaces part of a text string with a different text string using regular expressions. Learn more
Apri schedaREPLACE
REPLACE(text, position, length, new_text)
Replaces part of a text string with a different text string. Learn more
Apri schedaREPLACEB
REPLACEB(text, position, num_bytes, new_text)
Replaces part of a text string, based on a number of bytes, with a different text string. Learn more.
Apri schedaREPT
REPT(text_to_repeat, number_of_repetitions)
Returns specified text repeated a number of times. Learn more
Apri schedaRIGHT
RIGHT(string, [number_of_characters])
Returns a substring from the end of a specified string. Learn more
Apri schedaRIGHTB
RIGHTB(string, num_of_bytes)
Returns the right portion of a string up to a certain number of bytes. Learn more.
Apri schedaROMAN
ROMAN(number, [rule_relaxation])
Formats a number in Roman numerals. Learn more
Apri schedaSEARCH
SEARCH(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text. Learn more
Apri schedaSEARCHB
SEARCHB(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text counting each double-character as 2. Learn more
Apri schedaSPLIT
SPLIT(text, delimiter, [split_by_each], [remove_empty_text])
Divides text around a specified character or string, and puts each fragment into a separate cell in the row. Learn more
Apri schedaSUBSTITUTE
SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])
Replaces existing text with new text in a string. Learn more
Apri schedaT
T(value)
Returns string arguments as text. Learn more
Apri schedaTEXT
TEXT(number, format)
Converts a number into text according to a specified format. Learn more
Apri schedaTEXTJOIN
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts. Learn more.
Apri schedaTRIM
TRIM(text)
Removes leading and trailing spaces in a specified string. Learn more
Apri schedaUNICHAR
UNICHAR(number)
Returns the Unicode character for a number. Learn more.
Apri schedaUNICODE
UNICODE(text)
Returns the decimal Unicode value of the first character of the text. Learn more.
Apri schedaUPPER
UPPER(text)
Converts a specified string to uppercase. Learn more
Apri schedaVALUE
VALUE(text)
Converts a string in any of the date, time or number formats that Google Sheets understands into a number. Learn more
Apri scheda