MIN MAX value separated by dash

[sans]

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

[Andrew-R]

How about this little user-defined function:

Please Login or Register  to view this content.

Then, with your data in cell A1:

=SplitString(A1,"MAX")

or

=SplitString(A1,"MIN")

[sans]

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

[Marcol]

Just for fun, select from the drop-down in this workbook, no VBa.

Add to the strings as required, the column can be any length.

[sans]

Thanks Marcol!