ExcelBanter - Converting column & row numbers to a cell reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Converting column & row numbers to a cell reference (https://www.excelbanter.com/excel-worksheet-functions/55466-converting-column-row-numbers-cell-reference.html)

Graham Tritton

Converting column & row numbers to a cell reference

I need to convert the column and row numbers into a cell reference. EG.

2,10 converts to B10
10,5 converts to J5

Anyone have any ideas?

Jezebel

Converting column & row numbers to a cell reference

Use the Address() function.

"Graham Tritton" wrote in message
...
I need to convert the column and row numbers into a cell reference. EG.

2,10 converts to B10
10,5 converts to J5

Anyone have any ideas?

Biff

Converting column & row numbers to a cell reference

Hi!

Try these:

=ADDRESS(10,2,4) = B10
=ADDRESS(5,10,4) = J5

Biff

"Graham Tritton" wrote in message
...
I need to convert the column and row numbers into a cell reference. EG.

2,10 converts to B10
10,5 converts to J5

Anyone have any ideas?

All times are GMT +1. The time now is 11:55 PM.