need help with this formula

[shumonsaha]

Hi

If I have weekdays in a single cell as "WedFriTueSatMonThuSat"

I want to put a formula wherein it gets sorted as "SunMonTueWedThuFriSat"

Is there any excel formula to do it?

 

[mikerickson]

Why is Sun part of the result?
Are the days always contiguous, might "MonWedFri" be an input string?

 

[shumonsaha]

See, the program A has mon sun wed sat thu for eg

but when I do a Mconcat - unique values it takes in the same order as monsunwedsatthu

I want it to be in order sunmonwedthusat

does that clarify somewhat?

 

[mikerickson]

If "WedFriTueSatMonThuSat" is in A1, the formula

=MID(A1,FIND("Sun",A1&"Sun"),3) & MID(A1,FIND("Mon",A1&"Mon"),3) & MID(A1,FIND("Tue",A1&"Tue"),3) & MID(A1,FIND("Wed",A1&"Wed"),3) & MID(A1,FIND("Thu",A1&"Thu"),3) & MID(A1,FIND("Fri",A1&"Fri"),3) & MID(A1,FIND("Sat",A1&"Sat"),3)

will return "MonTueWedThuFriSat"

"Sun" is not part of the input of your example, I don't understand why it is part of the result. Was that a typo?

 

[shumonsaha]

No Sun is a part of the input.. too... sun stands for sunday and programs on TV can be scheduled in any part of the week.

will try the solution you have given

 

[shumonsaha]

Thanks Mike

That works perfectly