Two spaces between FName and LName

Question

Is there a formula that I can remove one space?Ex:&nbsp; Kathy&nbsp; Benjamin to Kathy BenjaminThank youTh

markshnier__you · Answer

try this as a formula text fieldList(" ",Part([Full Name],1, " "),Part([Full Name],2, " "),Part([Full Name],3, " "))

Forum Discussion