Forum Discussion

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
3 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

formulas

1 Reply

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 months ago

    try this as a formula text field

    List(" ",

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

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

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