Data Analy BIS 155

Convert Text to Columns (Chapter 10): Using the Broker Info spreadsheet, let’s learn how to convert text to columns. From the Data tab, use Text to Columns to separate the First and Last names. Format headings to say First Name, Last Name. Repeat the process to separate state and zip code and add the heading Zip Code.

Can you walk the class through the steps in order to complete this task?

Chapter_10.xlsx