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!"
Do you mean something like this?