Forum Discussion
Extract Cell Reference
I have a large spreadsheet that uses a simple formula to put data in a cell. In cell B2 is. "=b4" which is 25 In Cell A1 is the text "Fr: B4" that I keyed in manually after looking at the formula in...
Your description is confusing. Is the formula =B4 in B1 or in B2? And do you want A1 to refer to B1/B2 or to B4?
Anyway, you can use a formula like this in A1
="Fr: "&SUBSTITUTE(CELL("address",B4,"$","")Change B4 to suit your purpose.
When you insert or delete rows and/or columns, the result of the formula will be updated accordingly.