By Ken Bluttman

Part of Excel Formulas and Functions For Dummies Cheat Sheet

Excel’s text functions are very helpful when you’re working with names, addresses, customer lists, or any other text-based data. Here is list of Excel functions associated with text, along with a description of what each function does:

Function Description
LEFT Extracts one or more characters from the left side of a text
string
RIGHT Extracts one or more characters from the right side of a text
string
MID Extracts characters from the middle of a text string; you
specify which character position to start from and how many
characters to include
CONCATENATE Assembles two or more text strings into one
REPLACE Replaces part of a text string with other text
LOWER Converts a text string to all lowercase
UPPER Converts a text string to all uppercase
PROPER Converts a text string to proper case
LEN Returns a text string’s length (number of
characters)