Hi and welcome
Try the following:
say your data is in col A
In B1 enter =RIGHT(A1,LEN(A1)-4)+0 and double click the handle in the right lower corner to extend the formula
Then select data from col A and B and sort by Col B ( you can hide this column if needed)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post