MIN MAX value separated by dash

Hello,

I'd like to find the min & max value of a cell where values are separated by dash, for example, 1-2-5-6-7-19-0. I tried using the LEN function but haven't managed to get the correct result.

Thank you, Sans

How about this little user-defined function:

Function SplitString(sTargetString As String, sOperation As String, Optional sDelimiter = "-") As Variant

Dim sSplit As String

sSplit = "{" & Replace(sTargetString, sDelimiter, ";") & "}"

SplitString = Evaluate("=" & sOperation & "(" & sSplit & ")")

If IsError(SplitString) Then
  SplitString = "#VALUE"
End If

End Function

Then, with your data in cell A1:

=SplitString(A1,"MAX")

or

=SplitString(A1,"MIN")

Excellent, Andrew! Thank you very much, it worked great! This way I can get min and max values between many cells easily as well, i.e. =SplitString(A1&C1&H1,"MAX")

Many thanks, Sans

Thanks Marcol!