MAX with Text and Numbers

  • Thread starter Thread starter David Jr
  • Start date Start date
D

David Jr

All,

I am trying to use the MAX function with a cell that contains text and
numbers.

Example: MAX(A1:A2)

Where A1 contains John 25
Where A2 contains Mike 44

My return is a 0.

Please help

Thanks
 
It's better to populate cells, if possible, with atomic bits of data for
it's is easier to manipulate them.
That said...

=MAX(--(REPLACE(A1:A2,1,SEARCH(" ",A1:A2),"")))

which must be confirmed with control+shift+enter instead of just with enter.
 
Back
Top