Simplest way to extract Row number from a cell address reference

[2Took]

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,"$","")))))

 

[Joe4]

Caveat is that even if you have it, and your workbook's user does not -- it's not gonna work for them, I'm guessing. Sometimes sticking to the meat & potatoes works best

I guess that might depend on whether you are developing for others, or just yourself.
If developing for others, it is usually best to develop with an eye on the oldest version of Excel your users may be using (within reason! ).

 

[2Took]

Hi

=ROW(INDIRECT(L1))

That's the one I was looking for - we have a Winner. I errored in reverse - wrapped the ROW into INDIRECT