Skip to content

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

All functions

  • CONCATARALIKBİRLEŞTİRFull page

    Joins texts and ranges.

    =CONCAT(text1, [text2], ...)
  • CONCATENATEBİRLEŞTİRFull page

    Joins texts.

    =CONCATENATE(text1, [text2], ...)
  • FINDBULFull page

    Position of text (case-sensitive).

    =FIND(find_text, within_text, [start_num])
  • LEFTSOLDANFull page

    Characters from the start of a text.

    =LEFT(text, [num_chars])
  • LENUZUNLUKFull page

    Number of characters.

    =LEN(text)
  • LOWERKÜÇÜKHARFFull page

    Converts to lowercase.

    =LOWER(text)
  • MIDPARÇAALFull page

    Characters from the middle of a text.

    =MID(text, start_num, num_chars)
  • PROPERYAZIM.DÜZENİFull page

    Capitalises the first letter of each word.

    =PROPER(text)
  • REPLACEDEĞİŞTİRFull page

    Replaces characters at a position.

    =REPLACE(old_text, start_num, num_chars, new_text)
  • SUBSTITUTEYERİNEKOYFull page

    Substitutes new text for old text.

    =SUBSTITUTE(text, old_text, new_text, [instance_num])
  • TEXTMETNEÇEVİRFull page

    Formats a number or date as text ("dd/mm/yyyy", "#,##0.00", "0%", "mmmm", "dddd").

    =TEXT(value, format_text)
  • TEXTAFTERSONRAKİMETİNFull page

    Text after a delimiter.

    =TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])
  • TEXTBEFOREÖNCEKİMETİNFull page

    Text before a delimiter.

    =TEXTBEFORE(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])
  • TEXTJOINMETİNBİRLEŞTİRFull page

    Joins texts with a delimiter.

    =TEXTJOIN(delimiter, ignore_empty, text1, ...)
  • TEXTSPLITMETİNBÖLFull page

    Splits text by delimiters (array).

    =TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
  • TRIMKIRPFull page

    Removes extra spaces.

    =TRIM(text)
  • UPPERBÜYÜKHARFFull page

    Converts to uppercase.

    =UPPER(text)
  • VALUESAYIYAÇEVİRFull page

    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])

Excel functions →

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