How to Combine First & Last Name Columns in Excel. In previous versions of Excel, you had to combine first and last names using the Concatenate function, or its shortcut "&" method. Those methods ...

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

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 ...

Column functions and Columns functions are Lookup and Reference functions in Microsoft Excel. The Column function returns the column number of a reference, and its formula is Column([reference]).

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

Want to transpose Rows into Columns in Excel or Google Sheets? This post shows how to switch or swap Columns and Rows in Excel and Google Sheets.

How to Hide Columns and Rows in Excel Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide. Then, right-click on ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.