Skip to main content
Question

Two spaces between FName and LName

  • Apr 24, 2025 2:18 PM UTC
  • 0 replies
  • 50 views

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, " "))