probably the simplest way would be to 'copy-paste special-values'

this removes any formulas & then you can sort as required