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.

Excel CHAR Function

This post will guide you how to use Excel CHAR function with syntax and examples in Microsoft excel.

Description

The Excel CHAR function returns the character specified by a number (ASCII Value)

The CHAR function is a build-in function in Microsoft Excel and it is categorized as a Text Function.

The CHAR function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the CHAR function is as below:
=CHAR(number)

Where the CHAR function argument is:

Number -This is a required argument. the number value is a ASCII value between 1 and 255.
Note: If you provided invalided number, such as: the number value is: <1 or >255, you will get an error from the excel CHAR function, it is like to be the “#VALUE!” error.
char error value

Example:

#1 get a character from number 65, 33,  in the computer’s character set
char 65
char33

More Excel Char Function Examples


  • Generate Random Character Strings
    To generate random character strings in excel, you should be generate random numbers, letters, and special characters. We have talked that how to generate a random number string with Excel RANDBETWEEN function in excel…
  • Generate Random Passwords
    To generate a Random and secure password in Excel, you can use a combination of the CHAR function, the RANDBETWEEN function and concatenation operator to build a new Excel formula….