Virtual column subtract first 4 or 5 numbers and first space

[Ratatosk]

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?

[Suvrutt_Gurjar · Accepted solution]

Please try

TRIM(RIGHT([Ordre],LEN([Ordre])-5))

[Ratatosk]

Suvrutt_Gurjar:

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.