Oct 30 2021 02:04 PM
Oct 30 2021 02:46 PM
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.