"Jim Thomlinson" wrote in message
...
Lets see if I can do a little better on this than I did on your last. Try
this formula to get the value

=VALUE(LEFT(A1,2)+(VALUE(MID(A1,4,1)))/10)

Where 12.2a or 12,2a is in cell a1

HTH


Yes that is excellent assuming there are no entries like 6.25a
/fredrik