I usually export to Access - then move to Excel.

Tony, you're absolutely right. But replacing a "M" with a 1, doesn't
reduce the number of day-of -week variations. There would still be a
huge number of combinations.

Tom, maybe I'm missing something, but all of my data is approx. 700+
rows and each is different. The schedule and shift data are not in
separate rows. Is there a way I can quickly format rows that contain
MTW--YS, FT3 to the format you define?

Thanks guys!