Formula Help?

[Brad1]

Trying to use the formula tool to turn this:

M-F,9:00AM-5:00PM;SA,7:00AM-8:00PM;SU,CLOSED

To:

MO,9:00-5:00PM;TU,9:00-5:00PM;WE,9:00-5:00PM;TH,9:00-5:00PM;FR,9:00-5:00PM;SA,8:00AM-7:00PM

Any help would be appreciated.  I'm guessing something like if left 3 then MO + plus mid 7 elseif Wildcard "Closed" - Somehow trim that.   The fly in the ointment is they could be close on a Tuesday. 

Sometimes, the days are all spelled out due to different hours M-F.  I assuming one large if-then can do it?

[jdunkerley79 · Accepted solution]

I would suggest doing it as a lookup to replace the M-F (and other cases as needed).

You can then join and process (e.g. filter closes) before putting back together as a single string.

A Regex approach would be possible I think the above is simpler

[Brad1]

Works great!   Thanks!