Skip to main content
Solved

Is it possible to remove spacing between words using formula

  • April 15, 2020
  • 2 replies
  • 164 views

Forum|alt.badge.img

is it possible to remove spacing between words using formula

Best answer by kuovonne

Do you want to remove all spaces, or only some?

You can replace the space character with an empty string using the SUBSTITUTE function. It is documented in the formula field reference.

SUBSTITUTE({field name}, " ", "")

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Answer
  • April 15, 2020

Do you want to remove all spaces, or only some?

You can replace the space character with an empty string using the SUBSTITUTE function. It is documented in the formula field reference.

SUBSTITUTE({field name}, " ", "")

Forum|alt.badge.img
  • Author
  • New Participant
  • April 15, 2020

Do you want to remove all spaces, or only some?

You can replace the space character with an empty string using the SUBSTITUTE function. It is documented in the formula field reference.

SUBSTITUTE({field name}, " ", "")

Thank you Kuovonne it worked perfectly :heart_eyes: