Hi guys,
I frequently get a excel sheet with the numbers "1234567" or perhaps "12" in one cell to signify all days of the week in the first case or only Monday and Tuesday in the second case.
My question is that is there a quick way to convert the "1234567" text into days of the week? I believe the TEXT function can change one or two numbers into days but what about such a string?
I frequently get a excel sheet with the numbers "1234567" or perhaps "12" in one cell to signify all days of the week in the first case or only Monday and Tuesday in the second case.
My question is that is there a quick way to convert the "1234567" text into days of the week? I believe the TEXT function can change one or two numbers into days but what about such a string?