TEXTSPLIT and SORT

[nburaq]

Hi Gents,
I have combined intervals with "/" and I would like to split them in an ascending order is it possible to do that?
A2 B2 C2 D2 E2 F2 G2 H2 I2

4 Weeks / 6 Weeks / 12 Weeks / 6 Months / 1 Year / 2 Years / 3 Months / 3 Years

4 Weeks

6 Weeks

12 Weeks

6 Months

1 Year

2 Years

3 Months

3 Years

I can split the text with Textsplit function but when I use the Sort Function it doesnt sort like 4 Weeks 6 Weeks 12 Weeks 3 Months 6 Months 1 Year 2 Years 3 Years. Maybe I can convert to splitted text to days for each column and then sort again?

Already Thanks for all comments and help

 

[Georgiboy]

This one works perfect! I will not ask how because seems very complicated to me Thanks again for your help!!!

You're welcome