A long-time reader sent me an interesting problem this past week.

The problem is that the weekdays are input as yes/no abbreviations like “NYNYNYN” for “MWF”.

Note: you are free touse line breaksinside the formula bar to make formulas easier to read.

Option #2- TEXTJOIN and MID function:

This solution usesarray constantsto simply the formula considerably.