find the max of a range of numbers which are preceded with a letter

[yky]

I have a range of numbers which are preceded with a letter, e.g. A1392, A1587, A987, A3021, etc. Is there a way to find the maximum number of the numeric portion without using a help column?

 

[James006]

Hi,

You can test following Array formula

=MAX(SUBSTITUTE(A1:A4,"A","")*1)

Hope this will help

 

[Jaafar Tribak]

Or this Array formula:

{=MAX(IFERROR(MID(A1:B10;2,LEN(A1:B10))*1,0))}