I want to total the numbers in a row of cells with different notations.
I am working on a timesheet where the daily credit hours, annual and sick
leave are noted, and totaled. I am doing this manually now, I would like to
do it excel.
Mon Tues Wed Thu Fri Annual total Credit Earned Credit Used
2cre 1cru 1cre 1a 1cre 1 4
1

Is it possible to put this in excel? I want the function to
recognize/distinguish between the 'cre', 'cru' and 'a' notations.