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
excel sort function1

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
Calculate Retirement Date 10

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
convert week to date4

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
vlookup from another worksheet

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 ...

Excel DVARP Function
excel dvarp examples1

This post will guide you how to use Excel DVARP function with syntax and examples in Microsoft excel. Description The Excel DVARP Function will get the variance of a population based on the entire population of numbers in a column ...

Excel DVAR Function
excel dvar examples1

This post will guide you how to use Excel DVAR function with syntax and examples in Microsoft excel. Description The Excel DVAR Function will get the variance of a population based on a sample of numbers in a column in ...

Excel DSUM Function
excel dsum examples1

This post will guide you how to use Excel DSUM function with syntax and examples in Microsoft excel. Description The Excel DSUM Function will add the numbers in a column or database that meets a given criteria. And so you ...

Excel DSTDEVP Function
excel dstdevp examples1

This post will guide you how to use Excel DSTDEVP function with syntax and examples in Microsoft excel. Description The Excel DSTDEVP returns the standard deviation of a population based on the entire population of numbers in a column or ...

Excel DSTDEV Function
excel dstdev examples1

This post will guide you how to use Excel DSTDEV function with syntax and examples in Microsoft excel. Description The Excel DSTDEV returns the standard deviation of a population based on a sample of numbers in a column or database ...

Sidebar