Have a column of data that looks something like this:
All data starts with a "J" or "B". What I need to come up with is a nice formula that will do the following.
If the left most characters are J1, J2, J3, J4, J5 then "J M-F", if the first two characters are equal to J6 then "J SAT" or
if the first two characters are B1, B2,B3,B4,B5,B6 then "B".
I am running on empty today and having a time trying to make this work. Any help would be greatly appreciated as always.