Formula to remove spaces between numbers?

I have a long list of numbers but I'll use the below as an example:

In A1, I am starting with: 5 185%. I want this to end up as 5185.
In A2 I have the formula: =SUBSTITUTE(A1, " %", "") - This is removing the percentage sign.
In A3, I have the formula: =SUBSTITUTE(A2, " ", "") - this isn't removing the space for some reason? I can't even get this to work if I paste A2 over the top of itself as special values, it just won't remove the space.

Am I doing something wrong? I have to do this for a lot of numbers..

Thank you for any help! <3

^ Thanks for the above suggestions, it's much appreciated!

The =SUBSTITUTE(SUBSTITUTE(A1,CHAR(160),""),"%","") code seemed to work!
Thank you so much :D