i have copied data from a website and would like to apply certain formulas to
it, but the data has 2 blank spaces after the last digit and therefore
formulas are not working.

I've tried trim, clean and neither are working.

Can anyone help?
Thanks