Forum Discussion
Sorting the Numbers in Text format
HI All,
I need help in sortign this issue. I have a numbers which in a text format in a string , which I want to sort in the Asc- desc.
I did the sorting, but 10X comes before 2X, i want to have ...
Anonymous is this what you are looking for?
Anonymous see attached, check logic in Power Query, you can tweak the logic on your larger dataset but this one is tested on this smaller dataset, I assume this will give you an idea and get started. Cheers!!
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Thanks parry2k