LEN
LEN(text)
Returns the length of a string. Learn more
Marketing
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.
515 formule trovate · pagina 11 di 11
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
LENB
LENB(string)
Returns the length of a string in bytes." Learn more.
Marketing
Apri schedaLOWER
LOWER(text)
Converts a specified string to lowercase. Learn more
Marketing
Apri schedaMID
MID(string, starting_at, extract_length)
Returns a segment of a string. Learn more
Marketing
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.
Marketing
Apri schedaPROPER
PROPER(text_to_capitalize)
Capitalizes each word in a specified string. Learn more
Marketing
Apri schedaREGEXEXTRACT
REGEXEXTRACT(text, regular_expression)
Extracts matching substrings according to a regular expression. Learn more
Marketing
Apri schedaREGEXMATCH
REGEXMATCH(text, regular_expression)
Whether a piece of text matches a regular expression. Learn more
Marketing
Apri schedaREGEXREPLACE
REGEXREPLACE(text, regular_expression, replacement)
Replaces part of a text string with a different text string using regular expressions. Learn more
Marketing
Apri schedaREPLACE
REPLACE(text, position, length, new_text)
Replaces part of a text string with a different text string. Learn more
Marketing
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.
Marketing
Apri schedaREPT
REPT(text_to_repeat, number_of_repetitions)
Returns specified text repeated a number of times. Learn more
Marketing
Apri schedaRIGHT
RIGHT(string, [number_of_characters])
Returns a substring from the end of a specified string. Learn more
Marketing
Apri schedaRIGHTB
RIGHTB(string, num_of_bytes)
Returns the right portion of a string up to a certain number of bytes. Learn more.
Marketing
Apri schedaROMAN
ROMAN(number, [rule_relaxation])
Formats a number in Roman numerals. Learn more
Marketing
Apri schedaSEARCH
SEARCH(search_for, text_to_search, [starting_at])
Returns the position at which a string is first found within text. Learn more
Marketing
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
Marketing
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
Marketing
Apri schedaSUBSTITUTE
SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])
Replaces existing text with new text in a string. Learn more
Marketing
Apri schedaT
T(value)
Returns string arguments as text. Learn more
Marketing
Apri schedaTEXT
TEXT(number, format)
Converts a number into text according to a specified format. Learn more
Marketing
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.
Marketing
Apri schedaTRIM
TRIM(text)
Removes leading and trailing spaces in a specified string. Learn more
Marketing
Apri schedaUNICHAR
UNICHAR(number)
Returns the Unicode character for a number. Learn more.
Marketing
Apri schedaUNICODE
UNICODE(text)
Returns the decimal Unicode value of the first character of the text. Learn more.
Marketing
Apri schedaUPPER
UPPER(text)
Converts a specified string to uppercase. Learn more
Marketing
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
Marketing
Apri schedaENCODEURL
ENCODEURL(text)
Encodes a string of text for the purpose of using in a URL query. Learn more.
Automazione
Apri schedaHYPERLINK
HYPERLINK(url, [link_label])
Creates a hyperlink inside a cell. Learn more
Automazione
Apri schedaIMPORTDATA
IMPORTDATA(url)
Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format. Learn more
Automazione
Apri schedaIMPORTFEED
IMPORTFEED(url, [query], [headers], [num_items])
Imports a RSS or ATOM feed. Learn more
Automazione
Apri schedaIMPORTHTML
IMPORTHTML(url, query, index)
Imports data from a table or list within an HTML page. Learn more
Automazione
Apri schedaIMPORTRANGE
IMPORTRANGE(spreadsheet_url, range_string)
Imports a range of cells from a specified spreadsheet. Learn more
Automazione
Apri schedaIMPORTXML
IMPORTXML(url, xpath_query)
Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Learn more
Automazione Marketing
Apri schedaISURL
ISURL(value)
Checks whether a value is a valid URL. Learn more
Automazione
Apri scheda