Placing Col & Row identifiers into a cell as text
How do I get the Col letter and Row number of a cell (without the page name)
to appear as text in another cell?
Using the =CELL("address",xxx) and clicking on another page for the xxx cell
places the entire [workbook name]sheetname!$col$row in the cell. I only want
the col letter and the row #. How do I get only these?
|