String Order Formula/Macro

[Steve Morris]

I am trying to apply a formula or macro to convert each string in a particular order based on days of week (MTWRFSU). For the first example, it should be MTS to follow the pattern. Each cell could have anywhere between 1 and 7 letters.

TMS
FMS
WFUMS
SM
RMT
FSMT
FMT
SMT
MT
WMT
MFT
RSMTF
MTF
WSMTF
FMTSU
WSMTFU
FMTU
MRTFU
TMFU
SMTFU
RSMT
WMTR
WFMTR
SMTRF
WMTRF
WFMTRSU

 

[vletm]

Add/Delete/Change 'strings' to column B
Press [START]
Answer questions
You'll see the result.

 

[Steve Morris]

That was perfect...Thank You.

 

[NARAYANK991]

Hi ,

There seems to be a problem in the order of Friday and Saturday.

Narayan

 

[vletm]

@NARAYANK991
The default value was wrong in the code (Fri <> Sat).
That value can user change as user wants.
I changed the default value.
+ Shows the Default value.
> Animation has changed.