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.

How to use Text Formulas in Excel

The article in this webpage describes how to use the Text functions in Excel with the syntax, arguments, detailed explanation, and examples step by step.

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

Function

Description

ARRAYTOTEXT Function

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

BAHTTEXT Function

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

CHAR Function

Provide the character based on a number.

CLEAN Function

Remove all nonprintable characters from the text.

CODE Function

Numeric code for the first character in the text.

CONCAT Function

Combine the text from multiple cells into a single cell.

DOLLAR Function

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

EXACT Function

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

FIND Function

Search one text within another text and results their position.

FIXED Function

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

LEFT Function

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

LEN Function

Provide the total number of characters in the text string.

LOWER Function

Convert all the uppercase letters in the text to lowercase.

MID Function

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

NUMBERVALUE Function

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

PROPER Function

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

REPLACE Function

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

REPT Function

Repeat the text a specified number of times.

RIGHT Function

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

SEARCH Function

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

SUBSTITUTE Function

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

T Function

Check whethre its text or not.

TEXT Function

Convert the number to text format.

TEXTAFTER Function

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

TEXTBEFORE Function

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

TEXTJOIN Function

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

TEXTSPLIT Function

Split the text by using column and row delimiters.

TRIM Function

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

UNICHAR Function

Convert the number into Unicode character.

UNICODE Function

Convert the first Unicode character in the text into number.

UPPER Function

Convert all the lowercase letters in the text to uppercase.

VALUE Function

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

VALUETOTEXT Function

Convert the numeric value to text.

Learn More

Function

Description

XLOOKUP Function

Search for a specified value from a table or range of cells.

DATEDIF Function

Number of days, months or years between two dates.

0 Comments

Excel Formulas (Category)

» Financial Formulas in Excel

» Logical Formulas in Excel

» Text Formulas in Excel

» Date and Time Formulas in Excel

» Lookup and Reference Formulas in Excel

» Math and Trig Formulas in Excel

» Statistical Formulas in Excel

» Engineering Formulas in Excel

» Cube Formulas in Excel

» Information Formulas in Excel

» Compatibility Formulas in Excel

» Web Formulas in Excel

Excel Tutorial Part 1 (Basic)

» Excel Basics

» Excel Home

» Excel Workbook

» Excel Template

» Excel Cell

» Excel Password

Excel Tutorial Part 2 (Format)

» Excel Clipboard

» Excel Format Font

» Excel Format Alignment

» Excel Format Number

» Excel Border

» Excel Conditional Formatting

Excel Tutorial Part 3 (Data)

» Excel Sort Data

» Excel Filter Data

» Excel Text to Columns

» Excel Data Validation

» Excel Flash Fill

» Excel Remove Duplicates

» Excel Relationships

» Excel Consolidate

» Excel What-If Analysis

» Excel Group

» Excel Charts

» Excel Table

» Excel PivotTable

Excel Tutorial Part 4 (Find)

» Excel Find and Replace

» Excel Go To

» Excel Select Objects

» Excel Selection Pane

Excel Tutorial Part 5 (Review)

» Excel Spell Check

» Excel Smart Lookup

» Excel Translate

» Excel Comments & Notes

» Excel Protect

» Excel Hide Ink

Excel Tutorial Part 6 (View)

» Excel Workbook Views

» Excel Formula Bar

» Excel Zoom

» Excel Window

» Excel Macros

Excel Tutorial Part 7 (Fx)

» Excel Formulas (Category)

» Excel Formulas (Alphabetical Order)

» Excel Errors

» Excel Name Manager

» Excel Formula Auditing

» Excel Watch Window

» Excel Calculation Options

Excel Tutorial Part 8 (Other)

» Excel Add-ins

» Excel Shortcuts