Text Functions
Excel's text functions enable you to extract, convert, concatenate, and get information about text. I tell you about a few of the more commonly used ones here.
The LOWER, UPPER, & PROPER functions
The LOWER, UPPER, and PROPER functions (Figure 80) convert text to lowercase, upper-case, and title case. They use the following syntax:
LOWER(text) UPPER(text) PROPER(text)
Figure 80. Use the LOWER, UPPER, and PROPER functions to change the case of text. The formulas in column B are shown in column C.
The text argument, which is required, is the text you want converted.
The LEFT, RIGHT, & MID ...
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.