Microsoft Office Tutorials and References
In Depth Information
Review Questions
FIGURE 9.18 Text to Column Menu
FIGURE 9.19 The Data Separated into Individual Columns
You will find these examples in the Excel Chapter 9 file and the text file called Text:
1. In the Review sheet of Chapter 9, parse the data in the last column.
City, State, and Zip
Vincenzo Alfano
167 Magnolia
Baltimore, MD 21200
Ye Bai
24 Golf Lane
Snow, OK 74567
Brad Barile
1017 Spring Ave
Wilbraham, MA 01095
Greg Bedard
6 Timber Road
Pittsford, NY 14534
Jaime Campbell
312 Maple Ave
Elwin, IL 62532
2. This time open the text
le named Text on the book
s web page data
les. Using
Excel, separate the data into individual columns.
Search JabSto ::

Custom Search