Hi,
We have data in column [Ordre] that comes in two varieties. 4 numbers and space, and 5 numbers and space.
3234 Nasa academy 22
22456 Space force 11
I’d like to sort by “Nasa academy 22” and “Space force 11” with a virtual column.
I’ve tried for hours and managed to get it working somehow, but with a comma and space (", Nasa academy 22")
Split([Ordre],trim(text(index(SPLIT([Ordre]," “),1))&” "))
There must be a cleaner way to do this. Any ideas?
Solved! Go to Solution.
Please try
TRIM(RIGHT([Ordre],LEN([Ordre])-5))
Thank you so much Suvrutt! This works very good and is much more elegant.
EDIT: I’d also like to point out that much of my problems came from the fact that sorting does not update in browser unless you do a hard refresh.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |