Text functions

How to use the REPLACE function

The REPLACE function substitutes a part of a text string based on the number of characters and length with a […]

How to use the TEXTSPLIT function

The TEXTSPLIT function lets you split a string into an array across columns and rows based on delimiting characters. Formula […]

How to use the TEXTAFTER function

The TEXTAFTER function extracts a string after a specific substring in a given value. Formula in cell E3: =TEXTAFTER(B3, C3) […]

How to use the TEXTBEFORE function

The TEXTBEFORE function extracts a string before a specific substring from a given value. Formula in cell E3: =TEXTBEFORE(B3, C3) […]

How to use the UNICODE function

Use the UNICODE function to return a Unicode number based on a character. Excel Function Syntax UNICHAR(text) Arguments text Required. […]

How to use the UNICHAR function

Use the UNICHAR function to calculate a character based on a number. Excel Function Syntax UNICHAR(number) Arguments number Required. The […]

How to use the CONCATENATE function

The CONCATENATE function lets you add text strings into one single text string. The function has been replaced by the […]

How to use the ASC function

The ASC function converts full-width (double-byte) characters to half-width (single-byte) characters. This function is for double-byte character set (DBCS) languages. […]

How to use the CONCAT function

The CONCAT function concatenates values from multiple cells. There is, however, no delimiting character or a way to ignore empty […]

How to use the T function

The T function returns a text value if the argument is a text value. Formula in cell C3: =T(B3) The […]

How to use the FIND function

The FIND function returns the position of a specific string in another string, reading left to right. Note, the FIND function […]

How to use the VALUE function

Converts a text string that represents a number to a number. This function is included for compatibility with other software. […]

How to use the CLEAN function

The CLEAN function deletes nonprintable characters in a value, more specifically, it is designed to delete the first 32 nonprinting […]

How to use the LEN function

The LEN function returns the number of characters in a cell value. Table of Contents LEN function Syntax LEN function […]

How to use the CHAR function

Use CHAR function to convert a number to the corresponding character. This is determined by your computers character set. Windows ANSI […]

How to use the CODE function

The CODE function returns a specific number for the first character of the text argument, determined by your computer's character […]

How to use the LOWER function

The LOWER function converts a value to lower case letters. Formula in cell C3: =LOWER(B3) Table of Contents LOWER Function […]

How to use the REPT function

The REPT function repeats a specific text a chosen number of times. Formula in cell D3: =REPT(B3,C3) Table of Contents […]

How to use the SUBSTITUTE function

Formula in cell E3: =SUBSTITUTE(B3,C3,D3) The SUBSTITUTE function replaces a specific text string in a value. It is case sensitive […]

How to use the UPPER function

Converts a value to upper case letters. Formula in cell C3: =UPPER(B3) Table of Contents UPPER Function Syntax UPPER Function Arguments UPPER Function […]

How to use the EXACT function

The EXACT function allows you to check if two values are precisely the same, it returns TRUE or FALSE. The […]

How to use the TRIM function

The picture above shows you values that have multiple leading and trailing blanks, sometimes also multiple blanks between words. The […]

How to use the RIGHT function

The RIGHT function extracts a specific number of characters always starting from the right. Excel Function Syntax RIGHT(text,[num_chars]) Arguments text […]

How to use the LEFT function

The LEFT function extracts a specific number of characters always starting from the left. Formula in cell C3: =LEFT(B3, 1) […]

How to use the MID function

The MID function returns a substring from a string based on the starting position and the number of characters you want […]

How to use the TEXT function

This article demonstrates how to use the TEXT function in great detail. The formula in cell D3 formats the number […]

How to use the TEXTJOIN function

The TEXTJOIN function is a relatively new function introduced in Excel 2019, it is like the CONCATENATE function on steroids […]

How to use the SEARCH function

Returns a number representing the position a substring is, if found in a textstring. FIND is case sensitive and SEARCH is not.