Spaces in a Phone Number

I have used the Trim function in Number Formatter to get rid of the spaces in a phone number eg 123 456 789. i need to to be 123456789, but it hasn't worked.
Am i missing something?

Cheers

Trim removes extra spaces, replace removes all spaces.

Thank you, its working.