Formula to get the max or min value in a cell where numbers are delimited by-CodePudding

I have a set of data where i need to find the max or min values, from a cell where each numbers are delimited by sign.

19 11 9 26 89 10

I used text to columns and then find the max value for above by using the MAX function

=MAX(B2:G2)

, is there any better way to get the max or min value without using the text to columns.

CodePudding user response：

You may try,

=MAX(FILTERXML("<a><b>"&SUBSTITUTE(B2," ","</b><b>")&"</b></a>","//b"))

Or, If you are using O365 and currently in Office Insiders Beta Channel Version, then try using the TEXTSPLIT() Function,

=MAX(--TEXTSPLIT(B2," "))