Skip to main content
Question

Two spaces between FName and LName

Forum|alt.badge.img+5

Is there a formula that I can remove one space?

Ex:  Kathy  Benjamin to Kathy Benjamin

Thank you

Th

MarkShnierYou
Forum|alt.badge.img+24

try this as a formula text field

List(" ",

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

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

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

Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement