I have set up a formula to read a cell with the value "a1" and split into two
parts "a" and "1" using the right and left functions, but when I try to
count the value (1) it sees it as text instead of an integer. Is there a
function that converts the string to a number? A1 means annual leave 1 hr. I
have other codes such as "S8" which is sick leave 8 hrs. I'm trying to create
a formula that calculates the differnt types of leave in a list of cells
which represent a calendar. I could do this with multiple columns, but I'm
trying to keep the information all in one cell, so it can be in a calendar
format.

Thanks.