Adding space between Excel columns is usually a simple matter of increasing your column widths. But when the columns contain different types of data, such as numbers and text, increasing the width ...

So, to fix the random numbers you generated (I used the RAND function in my example below), select the cells containing those ...

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

Click "Finish" to close the wizard and your phone number will appear as a series of numbers spread out over several columns.

In two-dimensional XLOOKUP formulas, it doesn't matter which way around the XLOOKUPs go. In this example, the ID lookup is first in the formula, and the column header lookup is nested. If these were ...