Hi Guys,

Would greatly appreciate your help with a problem that has stumped me.

I have answers in one cell ranging from a blank cell, 'Mon' all the way to 'Mon;#Tue;#Wed;#Thu;#Fri' (any number of days can appear in the one cell)

If the response appears in A1 then I would like for the following.

In B1: If the word 'Mon' appears to return a 1
In C1: If the word 'Tue' appears to return a 1
all the way through to F1 for 'Fri'

I would also like blank cells to remain blank and have no error or '0'

Thank you in advance.