SORT PROPERTIES

[#1]

hi !!

could anyone help me with the sort properties?

i have attached an excel file with my issue..

you see i want to sort  some sizes in order because qlick sawing them to me a little bit stirred

qlick saws (14,15,16,14H,15H,16H) and i want (14,14H,15,15H,16,16H)

is there an expression for this???

thank you!

[stigchel]

In sort tab check the sort by expression only and use something like

=KeepChar(SIZEDESCR,'0123456789')

[#3]

thank you very much!!

[stigchel · Accepted solution]

You're welcome. if you found my solution correct, could you mark my answer as correct? This way the thread is closed, so others know no more help is required. Also others with a similar problem might find a solution to their problem easier.