View Single Post
  #1   Report Post  
Biff
 
Posts: n/a
Default 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?