21st January 2006, 06:59 AM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by La Mer
Just as an aside Davez, how would go about handling odds which are a mixture of numbers & letters such as 4/5F or 4/11F - can they be turned from text into numeric?
|
A1 = 4/11f (say)
B1 =IF(RIGHT(A1,1)>"9",LEFT(A1,LEN(A1)-1),A1)
C1 =FIND("/",B1)
D1 =LEFT(B1,C1-1)/RIGHT(B1,LEN(B1)-C1)+1
Hardly my bag, but above should work for stated conditions.
B1 strips off any 1 non-numeric on right |