I am working on a spreadsheet to calculate, on a biweekly basis, time taken. This is in a spreadsheet that will show time taken for the year. I have the sheet working and calculating time fine. That is not my problem. My problem is if on one day someone takes off two types of time.

Entries are CT for comp taken, S for Sick taken, AL for Admin leave and V for Vacation. I am having a problem with this, because there can be any number of combinations of these entries.

What I want to do is to pick the number out of the entry and have it placed into a column for that type of leave.

Given an entry such as:
Assume this is in Cell B5:

S2, CT5

Assume I have a column labeled Sick in C4 and a Column labeled Comp in D4, Admin Leave in E4 and a column labeled Vacation in F4. How do I pluck the # from each of the entries and place it in the appropriate column (a 2 in C5 and a 5 in D5)?

Keep it as simple as possible, as I am a neophite who is very appreciative of anyone who can help. I could really quit with what I have, and most of the other folks using this would be happy with it, but it is bugging me that I can't get it to do what I really want it to do.

Thanks