Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

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.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.