Converting column & row numbers to a cell reference

Graham Tritton · Nov 15, 2005

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 · Nov 15, 2005

Use the Address() function.

Biff · Nov 15, 2005

Hi!

Try these:

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

Biff