Help

Is it possible to remove spacing between words using formula

Topic Labels: Formulas
Solved
Jump to Solution
9201 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Momin_Bannani
5 - Automation Enthusiast
5 - Automation Enthusiast

is it possible to remove spacing between words using formula

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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: