Hi,

I am working on a spreadsheet for doctors and nursing who are/were preceptors (taught/ practiced) at our location.

I have been struggling to find a way to sort their names by year or semester.

This is a screenshot of what I am working with

\1

For example "F09" means fall semester 2009 "S" means spring semester and "U" means summer semester


I had an idea to make new values in a new cell and use some sort of IF or CONTAIN function to search the semester and year boxes and convert it into their proper year/semesters fully written out.

Lets pretend that the semester column is "L" and the Course column is "M"

Could somebody please come up with some sort of formula for me that would allow me to take the value in column L and convert that into
for example the year. For example if column L contains S09 I want that converted to 2009 if U09 I want that converted to 2009 as well, regardless of whether its spring or summer.

But then I need another formula that would give me both year and semester for example I would want F10 converted to "Fall 2010"