Breaking up string to find max number

[SarahK2000]

Hello All,

I am trying to find the maximum number in a range by breaking up a string

For example

I have
xxxxxxxx-01
xxxxxxxx-02
xxxxxxxx-03

I would appreciate some assistance in arriving at a formula as everyone I create using Find or Right functions falls short!

the answer to the above would be 03, the string will be of the same length each time.

thanks

Sarah

[ChemistB]

This will work as an arrayed function (Must use CNTRL + SHFT + ENTER instead of ENTER)

Please Login or Register  to view this content.

[SarahK2000]

This will work as an arrayed function (Must use CNTRL + SHFT + ENTER instead of ENTER)

Please Login or Register  to view this content.

Thanks for the reply!

however, the numbers can increment in the thousands and wouldn't be limited to the last two digits.

appreciate your help with this

[CARACALLA]

B1=aggregate(14,6,mid(a1:a100,search("-",a1:a100)+1,99)+0,1)

[Rick Rothstein]

Here is an array-entered** formula that should work...

=MAX(0+TRIM(RIGHT(SUBSTITUTE(A1:A3,"-",REPT(" ",99)),99)))

**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

Note: Change the highlighted range to your actual range of values.