Row numbers are easy to identify because they use numbers on the left side of a workspace. So even if you use a very large dataset, you can always look at the left side of the screen to see the number which corresponds to the row.

It’s much more complicated when it comes to columns because columns use letters instead of numbers.

Of course, there is no problem when we use a letter from the begging of the alphabet, but we need to think a bit when it comes to the letters closer to the end.

It’s even more complicated when we need to tell what is the number of, for example, column **NBJ.**

To determine these numbers, we can use functions **ROW** and **COLUMN.**

**ROW**shows the row number.**COLUMN**shows the column number.

Take a look at the following example.

**B3:** The **ROW** function returns **3** as the current row number.

**C3:** The **COLUMN** function returns **3** as the current column number (**C**).

**D3: ROW** returns **234** as the row number of cell **NBJ234.**

**D4:** **COLUMN** returns **9526** as the column number of cell **NBJ234.**