Microsoft Excel's "Text to Columns" feature lets you divide this data using two methods. If the data has an obvious deliminator, such as a comma between the last and first name, the "Delimited ...

Open Microsoft Excel, click the "File" tab, click "Open" and navigate to the worksheet to rename. Double-click the Excel file to open it in the main work area. Make any changes to the grid as desired.

In this article, you’ll learn how to hide and unhide columns, as well as the not-so-intuitive steps for unhiding column A. PREMIUM: Build your skills with this Excel power user guide.