### COLUMN Function Excel

This Excel Tutorial demonstrates how to use the Excel COLUMN Function in Excel to look up the column number, with formula examples.

## COLUMN Function Description:

The COLUMN Function Returns the column number of a cell reference.

## Formula Examples: Example Formula Result
Column C =COLUMN(C5) 3
Column E =COLUMN(E6) 5

## Syntax and Arguments:

The Syntax for the COLUMN Formula is:

### Function Arguments ( Inputs ):

reference – Cell reference that you want to determine the column # of.

Use the COLUMN Function to return the column number of a cell reference. What if you want the column letter of a cell reference? Use this complicated formula instead:
`=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")`
This formula calculates the column number with the COLUMN Function and calculates the address of a cell in row 1 of that column using the ADDRESS Function. Then it uses the SUBSTITUTE Function to remove the row number (1), so all that remains is the column letter.

`=AND(`  