Remove spaces from text field telephone numbers

[Guest]

I need to remove spaces in the text field of telephone numbers, and still
retain preceding zeroes.

 

[Douglas J Steele]

Use the Replace function:

Replace(MyTelephoneNumber, " ", "")