Skip to Main Content
Microsoft Excel 365 Bible
book

Microsoft Excel 365 Bible

by Michael Alexander, Dick Kusleika
March 2022
Beginner to intermediate content levelBeginner to intermediate
1072 pages
28h 16m
English
Wiley
Content preview from Microsoft Excel 365 Bible

CHAPTER 12Using Formulas to Manipulate Text

Often, the work you do with Excel not only involves calculating numbers but also includes transforming and shaping data to fit your data models. Many of these activities include manipulating text strings. This chapter will highlight some of the common text transformation exercises an Excel analyst performs and, in the process, give you a sense of some of the text-based functions that Excel has to offer.

Working with Text

When you enter data into a cell, Excel immediately goes to work and determines whether you're entering a formula, a number (including a date or time), or anything else. That “anything else” is considered text.

A single cell can hold up to 32,000 characters, but Excel is not a word processor, and there's no reason why anyone would need to come even close to that number of characters in a cell.

If you need to display lots of text in a worksheet, consider using a text box. Choose Insert ➪ Text ➪ Text Box, click the worksheet to create the text box, and then start typing. Working with large amounts of text in a text box is easier than editing cells. In addition, you can easily move, resize, or ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel 2019 Bible

Excel 2019 Bible

Michael Alexander, Richard Kusleika, John Walkenbach

Publisher Resources

ISBN: 9781119835103Purchase Link