ExcelFunctions.net
Excel Text Functions
Home »
Excel-Built-In-Functions »
Excel-Text-Functions
This page lists the current, built-in Excel Text Functions. These functions are provided by Excel, to
help you to work with text strings. They include functions to return information about a text string,
to apply formatting to a text string, to convert between text and other data types, and to cut up and
join together text strings.
The functions have been grouped into categories, to help you to find the function you need to perform
a specific task. Selecting a function name will take you to a full description of the function, including
examples of use, related tips & tricks and Common Errors.
Excel Text Functions List
|
Functions to Remove Extra Characters
|
|
CLEAN
|
Removes all non-printable characters from a supplied text string
|
|
TRIM
|
Removes duplicate spaces, and spaces at the start and end of a text string
|
|
Functions to Convert Excel Data Types
|
|
BAHTTEXT
|
Converts a number, plus the suffix "Baht" into Thai text
|
|
DOLLAR
|
Converts a supplied number into text, using a currency format
|
|
FIXED
|
Rounds a supplied number to a specified number of decimal places, and then converts this into text
|
|
TEXT
|
Converts a supplied value into text, using a user-specified format
|
|
VALUE
|
Converts a text string into a numeric value
|
|
Functions to Convert Between Upper & Lower Case
|
|
LOWER
|
Converts all characters in a supplied text string to lower case
|
|
PROPER
|
Converts all characters in a supplied text string to proper case
(i.e. letters that do not follow another letter are upper case and all other characters are lower case)
|
|
UPPER
|
Converts all characters in a supplied text string to upper case
|
|
Converting Between Characters & Numeric Codes
|
|
CHAR
|
Returns the character that corresponds to a supplied numeric value
|
|
CODE
|
Returns the numeric code for the first character of a supplied string
|
|
|
Replacing / Substituting Parts of a Text String
|
|
REPLACE
|
Replaces all or part of a text string with another string (from a user supplied position)
|
|
SUBSTITUTE
|
Substitutes all occurrences of a search text string, within an original text string,
with the supplied replacement text
|
|
Cutting Up & Piecing Together Text Strings
|
|
CONCATENATE
|
Joins together two or more text strings
|
|
LEFT
|
Returns a specified number of characters from the start of a supplied text string
|
|
MID
|
Returns a specified number of characters from the middle of a supplied text string
|
|
RIGHT
|
Returns a specified number of characters from the end of a supplied text string
|
|
REPT
|
Returns a string consisting of a supplied text string, repeated a specified number of times
|
|
Information Functions
|
|
LEN
|
Returns the length of a supplied text string
|
|
FIND
|
Returns the position of a supplied character or text string from within a supplied text string (case-sensitive)
|
|
SEARCH
|
Returns the position of a supplied character or text string from within a supplied text string (non-case-sensitive)
|
|
EXACT
|
Tests if two supplied text strings are exactly the same and if so, returns TRUE;
Otherwise, returns FALSE. (case-sensitive)
|
|
T
|
Tests whether a supplied value is text and if so, returns the supplied text;
If not, returns an empty text string.
|
|
An example of the use of Excel Text Functions to combine text with numbers is given on the
Microsoft Office Website
