Get to know minimum from a cell mentioning the range

[kshankar88]

Hello,
I have cells mentioning the ranges as mentioned below in Column A beginning with row1:

Nof workers Min no:
0-30 ?
31-60 ?
61-70 ?
71+ ?

I wanted to calculate the min no: before each tier. i.e. B2 should contain 0, B3 should contain 30, B4 should contain 60 and B5 should contain 70.
Is there a formula, I can use to parse columns A2-A5 to get B2-B5?

 

[mikerickson]

Here's an ugly effective formula.
The ugliness of this formula (and all the other formulas that will be offered) is a good reason that one shouldn't put two data in the same cell.

=LEFT(SUBSTITUTE(SUBSTITUTE(A2,"+","-"),"-"," "),5)-1

It would be a much cleaner spreadsheet if your column A were two columns

0 30
31 60
61 70
71 9E+99