### Text functions

How to use the VALUETOTEXT function

What is the VALUETOTEXT function? The VALUETOTEXT function returns a value in text form. Text values are unmodified and non-text […]

How to use the ARRAYTOTEXT function

What is the ARRAYTOTEXT function? The ARRAYTOTEXT function concatenates values from a given cell range or array using the comma […]

How to use the REPLACE function

What is the REPLACE function? The REPLACE function substitutes a part of a text string based on the number of […]

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

What is the UNICODE function? Use the UNICODE function to return a Unicode number based on the first character of […]

How to use the UNICHAR function

What is the UNICHAR function? The UNICHAR function in Excel returns the Unicode character corresponding to a given Unicode code […]

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 CONCAT function

What is the CONCAT function? The CONCAT function concatenates values from multiple cells, cell ranges and arrays. What is concatenate? […]

What is the T function? The T function returns a text value if the argument is a text value. The […]

What is the FIND function? The FIND function returns the position of a specific string located in another string, reading […]

What is the VALUE function? The VALUE function converts a text string that represents a number to a number. Table […]

What is the CLEAN function? The CLEAN function deletes nonprintable characters from a value in 7-bit ASCII code. Why delete […]

What is the LEN function? The LEN function returns a number representing the total count of characters in a given […]

Use the CHAR function to convert a number to the corresponding character. This is determined by your computer's character set. […]

What is the CODE function? The CODE function returns a numeric code for the first character of the text argument, […]

What is the LOWER function? The LOWER function converts a value to lower case letters. What are lower case letters? […]

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 […]

What is the UPPER function? The UPPER function converts letters in a value to upper case letters. Table of Contents […]

What is the EXACT function? The EXACT function allows you to check if two values are precisely the same, it […]

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

What is the RIGHT function? The RIGHT function extracts a specific number of characters always starting from the right. What […]

What is the LEFT function? The LEFT function extracts a specific number of characters always starting from the left. It […]

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

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.