Hi
I'm looking to write a function named "=HERE()", where when I insert =HERE() in cell B3 I get "B3" as result.
Looks easy for formulate, no to easy to get into the API.
Thanks
Use =CELL("address") in B3 => result "$B$3".
Though I didn't get what you mean with "to get into the API".
To only get the requested location (e.g. B3) without the $ one can combine the CELL function with the SUBSTITUTE function like this:
=SUBSTITUTE(CELL("Address"),"$","")
Though this would be good to add here.
To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!
Have a nice day and let's (continue to) "Be excellent to each other!"
Asked: 2020-08-28 18:59:18 +0200
Seen: 90 times
Last updated: Aug 28 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Do you mean something like this?