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.
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
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.