Excel Text Functions You'll Find Helpful - dummies

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)