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.

x
How to Replace # Errors with Zero or Any Specific Value in Excel

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

Excel DMIN Function
excel dmin function example1

This post will guide you how to use Excel DMIN function with syntax and examples in Microsoft excel. Description The Excel DMIN returns the minimum value from a database or a column of a list that matches the specified conditions. ...

Excel DPRODUCT Function
excel dproduct examples1

This post will guide you how to use Excel DPRODUCT function with syntax and examples in Microsoft excel. Description The Excel DPRODUCT returns the product of values from a set of records that match criteria that you specify. The DPRODUCT ...

Excel XIRR Function
excel xirr examples1

This post will guide you how to use Excel XIRR function with syntax and examples in Microsoft excel. Description The Excel XIRR function returns the internal rate of return for a series of cash flows that is not necessarily periodic. ...

Excel VDB Function
excel vdb examples1

This post will guide you how to use Excel VDB function with syntax and examples in Microsoft excel. Description The Excel VDB function calculates the depreciation of an asset for a specified period based on the double declining balance method. ...

Sidebar