How to use Headers and Footers Effectively in MS Excel

How to use Headers and Footers Effectively in MS Excel: Headers and footers are lines of text that print at the top (header) and bottom (footer) of each page in the spreadsheet. They contain descriptive text such as titles, dates, and/or page numbers.

Headers and footers are lines of text that print at the top (header) and bottom (footer) of each page in the spreadsheet. They contain descriptive text such as titles, dates, and/or page numbers.

Text to Column

To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’. For example, when you want to separate a list of full names into last and first names

Select the range with full names
On the Data tab, click Text to Columns

The following dialog box appears.

Choose Delimited and click Next.
Clear all the checkboxes under Delimiters except for the Comma and Space checkbox.
Click Finish

Note: This example has commas and spaces as delimiters. You may have other delimiters in your data. Experiment by checking and unchecking the different checkboxes. You get a live preview of how your data will be separated.