Excel functions · 46 functions
Excel text functions
Functions that cut, join, split, search, replace and format text: LEFT, MID, TRIM, SUBSTITUTE, TEXTJOIN, TEXTSPLIT, TEXT.
Functions explained in full
- CONCATJoins texts and ranges.
- CONCATENATEJoins texts.
- FINDPosition of text (case-sensitive).
- LEFTCharacters from the start of a text.
- LENNumber of characters.
- LOWERConverts to lowercase.
- MIDCharacters from the middle of a text.
- PROPERCapitalises the first letter of each word.
- REPLACEReplaces characters at a position.
- RIGHTCharacters from the end of a text.
- SEARCHPosition of text (case-insensitive, wildcards).
- SUBSTITUTESubstitutes new text for old text.
- TEXTFormats a number or date as text ("dd/mm/yyyy", "#,##0.00", "0%", "mmmm", "dddd").
- TEXTAFTERText after a delimiter.
- TEXTBEFOREText before a delimiter.
- TEXTJOINJoins texts with a delimiter.
- TEXTSPLITSplits text by delimiters (array).
- TRIMRemoves extra spaces.
- UPPERConverts to uppercase.
- VALUEConverts text that looks like a number to a number.
All functions
Joins texts and ranges.
=CONCAT(text1, [text2], ...)Joins texts.
=CONCATENATE(text1, [text2], ...)Position of text (case-sensitive).
=FIND(find_text, within_text, [start_num])Characters from the start of a text.
=LEFT(text, [num_chars])Number of characters.
=LEN(text)Converts to lowercase.
=LOWER(text)Characters from the middle of a text.
=MID(text, start_num, num_chars)Capitalises the first letter of each word.
=PROPER(text)Replaces characters at a position.
=REPLACE(old_text, start_num, num_chars, new_text)Characters from the end of a text.
=RIGHT(text, [num_chars])Position of text (case-insensitive, wildcards).
=SEARCH(find_text, within_text, [start_num])Substitutes new text for old text.
=SUBSTITUTE(text, old_text, new_text, [instance_num])Formats a number or date as text ("dd/mm/yyyy", "#,##0.00", "0%", "mmmm", "dddd").
=TEXT(value, format_text)Text after a delimiter.
=TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])Text before a delimiter.
=TEXTBEFORE(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])Joins texts with a delimiter.
=TEXTJOIN(delimiter, ignore_empty, text1, ...)Splits text by delimiters (array).
=TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])Removes extra spaces.
=TRIM(text)Converts to uppercase.
=UPPER(text)Converts text that looks like a number to a number.
=VALUE(text)- ARRAYTOTEXTDİZİMETİN
Text form of an array.
=ARRAYTOTEXT(array, [format]) - ASC
Changes full-width characters to half-width (no change in non-East-Asian locales).
=ASC(text) - CHARDAMGA
Character for a code.
=CHAR(number) - CLEANTEMİZ
Removes non-printable characters.
=CLEAN(text) - CODEKOD
Code of the first character.
=CODE(text) - DBCS
Changes half-width characters to full-width (no change in non-East-Asian locales).
=DBCS(text) - DOLLARLİRA
Formats a number as currency text.
=DOLLAR(number, [decimals]) - EXACTÖZDEŞ
TRUE if two texts are exactly the same.
=EXACT(text1, text2) - FINDBBULB
Byte position (same as FIND in single-byte languages).
=FINDB(find_text, within_text, [start_num]) - FIXEDSAYIDÜZENLE
Formats a number with fixed decimals.
=FIXED(number, [decimals], [no_commas]) - LEFTBSOLB
Leftmost bytes (same as LEFT in single-byte languages).
=LEFTB(text, [num_chars]) - LENBUZUNLUKB
Number of bytes (same as LEN in single-byte languages).
=LENB(text) - MIDBORTAB
Middle bytes (same as MID in single-byte languages).
=MIDB(text, start_num, num_chars) - NUMBERVALUESAYIDEĞERİ
Converts text to a number with given separators.
=NUMBERVALUE(text, [decimal_separator], [group_separator]) - REGEXEXTRACT
Extracts text matching a regular expression.
=REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity]) - REGEXREPLACE
Replaces text matching a regular expression.
=REGEXREPLACE(text, pattern, replacement, [occurrence], [case_sensitivity]) - REGEXTEST
Whether text matches a regular expression.
=REGEXTEST(text, pattern, [case_sensitivity]) - REPLACEBDEĞİŞTİRB
Replaces by bytes (same as REPLACE in single-byte languages).
=REPLACEB(old_text, start_num, num_chars, new_text) - REPTYİNELE
Repeats text.
=REPT(text, number_times) - RIGHTBSAĞB
Rightmost bytes (same as RIGHT in single-byte languages).
=RIGHTB(text, [num_chars]) - SEARCHBARAB
Byte position (same as SEARCH in single-byte languages).
=SEARCHB(find_text, within_text, [start_num]) - TM
Returns the text if the value is text.
=T(value) - UNICHARUNICODEKARAKTERİ
Unicode character.
=UNICHAR(number) - UNICODE
Unicode number of the first character.
=UNICODE(text) - USDOLLARABDDOLAR
Same as DOLLAR: formats a number as currency text.
=USDOLLAR(number, [decimals]) - VALUETOTEXTDEĞERMETİN
Text form of a value (1: strict, quoted).
=VALUETOTEXT(value, [format])
Stop memorising formulas. Describe them.
Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.
Try it free