Is there a formula to remove white space from a character field ?

[#1]

Is there a formula to remove white space from a character field. The data field is not supposed to have and white spaces or blank spaces within the field.

[#2]

Trim will remove white space at the beginning and or the end of the field. I'm not sure if it will remove white space in the middle of the field.

[#3]

VinKane​ : This will work :
   Name = "Vin Kane" ;
   regex(Name," ","","globalreplace");   // The first character is white space within quotations , the second character is just quotations without a space
ledi.trutna​ : Trim is not capable of replacing the spaces in between - but like you said it works for leading and trailing white spaces

[#4 · Accepted solution]

More accurately:

regex(text,"\s","",globalreplace);

Your code will only remove spaces, \s will find all white space in regex including tabs, carriage returns, new lines, and a host of other white space characters.