Finding and editing a text string

A B
1 2.66-3 ref
2 1-2 keys
3 1 key

These represent a value range. I wish to return the lowest number of the range along with the text at the end.

So i want B1 to equal 2.66 ref, B2 to equal 1 keys, and B3 to equal 1 key.

A B
1 2.66-3 ref 2.66 ref
2 1-2 keys 1 keys
3 1 key 1 key

Put this in B1:

Formula:

Please Login or Register  to view this content.

then copy down.

Hope this helps.

Pete

Thanks a million, Ive been tearing my hair out over this

Solution works perfectly