Under the home tab go to the rightmost box on the Excel Ribbon. Enter the formula to the first cell C1 A1XNT. In this example we need to select the cell F2 and double click on the bottom right corner.
Input your formula in the top cell.
Simply do the following. How to Use the MONTH Formula in Excel. Supposing you need to apply the formula of A1385 in the Column C and see the following tutorials to apply the same formula to entire Column C. Method 2 If you dont want to convert the data into Excel Table select the entire column where you want to apply the formula type in the formula in the active cell and press Ctrl Enter.