Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Chapter 6

Text functions and Flash Fill

Questions answered in this chapter:

• I have a worksheet in which each cell contains a combined product ID, a product description, and a product price. How can I separate all the product IDs to column C, all the prices to column D, and all the product descriptions to column E?

• Every day, I receive data about total US sales, which is computed in a cell as the sum of East, North, and South regional sales. How can I extract East, North, and South sales to separate cells?

• At the end of each school semester, my students evaluate my teaching performance on a scale from 1 to 7. I know how many students gave me each possible rating score. How can I easily create a bar graph of my teaching evaluation scores?

• I have ...