Excel Text Functions

This section will learn  how to use Excel’s Text functions such as: CHAR, CLEAN, FIND, LEFT, LEN, etc.

CHAR – returns the character specified by a number (ASCII Value)

CLEAN – removes all non-printable characters from a text string.

CODE – returns the numeric ASCII value for the first character of a text string.

EXACT – compares if two text strings are the same and returns TRUE if they are the same, Or, it will return FALSE.

FIND – returns the position of the first text string (substring) from the first character of the second text string.

DOLLAR – converts a number to text using currency format (such as: $ symbol), the currency format used depends upon your default language setting on your computer.

PROPER – capitalizes the first character in each word of a text string and set other characters to lowercase.

REPLACE – replaces all or part of a text string with another text string.

REPT – repeats a text string a specified number of times.

RIGHT – returns a substring (a specified number of the characters) from a text string, starting from the rightmost character.

SEARCH – returns the number of the starting location of a substring in a text string.

SUBSTITUTE – replaces a new text string for an old text string in a text string.

T –  returns the text referred to by value.

TEXT – converts a numeric value into text string with a specified format.

TEXTJOIN – joins two or more text strings together and separated by a delimiter.

UPPER – converts all characters in text string to uppercase.

VALUE – converts a text value that represents a number to a numeric value.

LEFT – returns a substring (a specified number of the characters) from a text string, starting from the leftmost character.

LOWER – converts all characters in a text string to lowercase.

CONCAT – combines 2 or more strings or ranges together.

MID – returns a substring from a text string at the position that you specify.

LEN – returns the length of a text string (the number of characters in a text string).

FIXED – rounds a number to the specified number of decimal places and returns the result as text string.

Related Posts

Excel SORT Function

The excel sort function is one of the most useful new features in Excel. It is one of many functions that make advantage of Excel's new dynamic array calculation engine, which enables Excel to spill results from a single formula ...

Excel TRANSPOSE Function

Excel TRANSPOSE formula allows you to rotate (swap) values from rows to columns and vice versa in Excel. Its goal, as a component of the Excel lookup and reference functions, is to arrange data in the appropriate manner. To run ...

How to Calculate Retirement Date and Remaining Years refer to Birth Date in Excel

Every company has its own police about the retirement date for employees. Suppose employees will be retired from a certain age of 60, how can we calculate the retirement date for everyone base on their birthdays? Actually, there are several ...

Converting Week Number to Date

This post will guide you how to convert a week number to a date with a formula in Excel. How do I calculate a date from a week number and a year with formula in Excel. Or how to get ...

Excel Vlookup From Another Workbook

This post will guide you how to lookup value from another workbook in Excel. How do I use VLOOKUP function across multiple workbooks in Excel. How to vlookup a value from another workbook with a formula in Excel. Excel Vlookup ...