How to Join Two Columns in Excel. When you're setting up a Microsoft Excel spreadsheet to build an employee directory, calculate product margins or project sales, you may run into circumstances in ...

This does not affect the data in column C when using Excel's capability to automatically combine text. To combine first and last names in cells A1 and B1 using functions, enter the following ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.