MIN function in combination with LEFT

Hello,

I have several cells with values or ranges of values:

Example from column A
0,005
0,001-0,002
0,003
0,002
0,006

I would like to find the minimum value

In this case the formula should take the 5 left characters from every cell and give the minimum result.

I was thinking to do this...

Please Login or Register  to view this content.

... but obviously it doesn't work.

I don't want to make a separate column unless it's necessary.

Thanks for your advice!

Try this:

=AGGREGATE(15;6;--LEFT(A1:A5;5);1)

Thanks so much Phuocam!
It works like a charm!