If cell L1 has literally $K$19 cell address in it, what is a simplest* way to extract that Row number 19 out of it?
*without having to use this: =RIGHT(L1,LEN(L1)-SEARCH("#",SUBSTITUTE(L1,"$","#",LEN(L1)-LEN(SUBSTITUTE(L1,"$","")))))
*without having to use this: =RIGHT(L1,LEN(L1)-SEARCH("#",SUBSTITUTE(L1,"$","#",LEN(L1)-LEN(SUBSTITUTE(L1,"$","")))))