Text Formulas in Excel

Text formulas in Excel are used to format the characters, find the text, replace the text, return the desired characters within the text and much more. The text formulas in Excel are helpful to transform the text easily based on the user needs.

In this tutorial page, you will learn how to use all the text formulas in Excel with detailed explanations, examples and videos.

Click on any of the below text formulas in Excel to get the detailed information about it.

Text Formulas in Excel | Rath Point

All Text Formulas in Excel

ARRAYTOTEXT Formula in Excel

BAHTTEXT Formula in Excel

CHAR Formula in Excel

CLEAN Formula in Excel

CODE Formula in Excel

CONCAT Formula in Excel

DOLLAR Formula in Excel

EXACT Formula in Excel

FIND Formula in Excel

FIXED Formula in Excel

LEFT Formula in Excel

LEN Formula in Excel

LOWER Formula in Excel

MID Formula in Excel

NUMBERVALUE Formula in Excel

PROPER Formula in Excel

REPLACE Formula in Excel

REPT Formula in Excel

RIGHT Formula in Excel

SEARCH Formula in Excel

SUBSTITUTE Formula in Excel

T Formula in Excel

TEXT Formula in Excel

TEXTAFTER Formula in Excel

TEXTBEFORE Formula in Excel

TEXTJOIN Formula in Excel

TEXTSPLIT Formula in Excel

TRIM Formula in Excel

UNICHAR Formula in Excel

UNICODE Formula in Excel

UPPER Formula in Excel

VALUE Formula in Excel

VALUETOTEXT Formula in Excel

Summary of all Text Formulas in Excel

ARRAYTOTEXT

Convert an array of text and non-text values into text.

BAHTTEXT

Convert a number to Thai text and adds a suffix of “Baht”.

CHAR

Provide the character based on a number.

CLEAN

Remove all nonprintable characters from the text.

CODE

Numeric code for the first character in the text.

CONCAT

Combine the text from multiple cells into a singel cell.

DOLLAR

Convert the number to text using currency format, add $ sign and round the decimal points.

EXACT

Compare two text strings and results as True if both are exactly same, else results as False.

EXACT

Compare two text strings and results as True if both are exactly same, else results as False.

FIND

Search one text within another text and results their position.

FIXED

Round the number to a specified number of decimals, with/without comma and converts to text.

LEFT

Provide the specified number of characters from the begining of the text string.

LEN

Provide the total number of characters in the text string.

LOWER

Convert all the uppercase letters in the text to lowercase.

MID

Provide the specified number of characters from the specified position of the text string.

NUMBERVALUE

Convert the text value to number by specified decimal and group separators.

PROPER

Convert the first character in the text as uppercase and rest as lowercase.

REPLACE

Replace part of the old text with new text based on the specified number of characters.

REPT

Repeat the text a specified number of times.

RIGHT

Provide the specified number of characters from the end of the text string.

Search one text within another text and provides the starting position number of the text.

SUBSTITUTE

Substitute the specific or all instances of the old text with the new text in a text string.

Check whethre its text or not.

TEXT

Convert the number to text format.

TEXTAFTER

Get the text that occurs after the specified character or string.

TEXTBEFORE

Get the text that occurs before the specified character or string.

TEXTJOIN

Combine the text from multiple cells by adding a specified delimiter.

TEXTSPLIT

Split the text by using column and row delimiters.

TRIM

Remove all extra spaces before and after the text by keeping only one space between each word.

UNICHAR

Convert the number into Unicode character.

UNICODE

Convert the first Unicode character in the text into number.

UPPER

Convert all the lowercase letters in the text to uppercase.

VALUE

Convert a text that appears as number to a numeric value.

VALUETOTEXT

Convert the numeric value to text.

» Financial Formulas

» Logical Formulas

» Text Formulas

» Date & Time Formulas

» Lookup & Ref Formulas

» Math & Trig Formulas

» Statistical Formulas

» Engineering Formulas

» Cube Formulas

» Information Formulas

» Compatibility Formulas

» Web Formulas