How to replace cell address into function of cell reference with function address

[Dossfm0q]

I want to replace the reference of Cell O4 with ADDRESS(4,15,4,1)


=CELL("contents",O4) to =CELL("contents",ADDRESS(4,15,4,1))

"=CELL(""contents"",[COLOR=#000080]O4[/COLOR])"

to be

"=CELL(""contents"",[COLOR=#000080][B]ADDRESS(4,15,4,1)[/B][/COLOR])"

 

[steve the fish]

Thats just =O4 isnt it? What are you using it for?

 

[Dossfm0q]

thanks for respond
Yes the =ADDRESS(4,15,4,1) will give O4 4 the number of row 15 number column

 

[steve the fish]

And the other question? What are you using it for?