Chapter 16

Writing Home About Text Functions


Bullet Assembling, altering, and formatting text

Bullet Figuring out the length of text

Bullet Comparing text

Bullet Searching for text

A rose is still a rose by any other name. Or maybe not, when you use Excel’s sophisticated text-manipulation functions to change it into something else. Case in point: You can use the REPLACE function to change a rose into a tulip or a daisy, literally!

Did you ever have to work on a list in which people’s full names are in one column, but you need to use only their last names? You could extract the last names to another column manually, but that strategy gets pretty tedious for more than a few names. What if the list contains hundreds of names? This is just one example of text manipulations that you can do easily and quickly with Excel’s text functions.

Breaking Apart Text

Excel has three functions that are used to extract part of a text value (often referred to as a string). The LEFT, RIGHT, and MID functions let you get to the parts of a text value that their name implies, extracting part of a text value from ...

Get Excel Formulas & Functions For Dummies, 5th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.