You can show or hide list of formulas while typing in Excel with the help of a shortcut key. Press Alt+Down arrow or make it invisible.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

How do you concatenate 3 columns in Excel? You can also use the concatenate function to combine more than two columns. Step 1: I typed in =CONCATENATE (A2,B2,C2) into its own cell.