Forum Discussion

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
2 months ago

Two spaces between FName and LName

Is there a formula that I can remove one space?

Ex:  Kathy  Benjamin to Kathy Benjamin

Thank you

Th

1 Reply

  • try this as a formula text field

    List(" ",

    Part([Full Name],1, " "),

    Part([Full Name],2, " "),

    Part([Full Name],3, " "))