Function Script Add All Days Used to one Cell Like CONCATENATE()

[realniceguy5000]

Good Day Everyone,

I have a problem with the following script. I was hoping someone could take a look and advise.

This script will add all the days used and place them in the same cell. For example if a person was working Mon (B2) and Tues(C2) the scipt will take the 2 enteries and add them to another cell (H2).so for the result would be (MON-TUE). The problem seems to be when I place Mon(B2) Tue(C2) and Weds(D2) In (H2) Results is (Mon - Weds). What I'm looking for is in (H2) is = (Mon,Tues, Weds)

I added a test book to help explain and here is the script I'm using...

Please Login or Register  to view this content.

I call the script from a cell in Col(H) with this.

Please Login or Register  to view this content.

Thank You for taking the time to help, Mike

[Bob Phillips]

Please Login or Register  to view this content.

[DonkeyOte]

You need to adopt some form of consistency so either Mon-Fri is ok (as is Mon-Wed) or it isn't - ie Mon,Tue,Wed,Thu,Fri etc...

Perhaps the below alternative might help ?

Please Login or Register  to view this content.

Bob's is obviously far simpler [and more robust]

[DonkeyOte]

I would still advocate Bob's approach given the small ranges in use however the below is a slightly more robust version of the prior suggestion:

Please Login or Register  to view this content.

[realniceguy5000]

Thanks for the quick responces...

Bob and DonkeyOte

I understand "consistency" that makes better sense anyway.I tested each script and the changes work for my needs, I appriciate your guys hard work.

Thank You for taking the time to look and solve my problem.

Mike