I have some high/low temperatures data in the following form:
101°/78°
81°/63°
25°/9°

I would like the high and low to be numbers in separate cells. I came up with these formulas, but they work only if both temperatures are 2 digits:
=VALUE(LEFT(A1,2))
=VALUE(MID(A1,5,2))

I need a formula that works for all of the above examples. Using Excel 97. Thanks.

Ken