Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Is it possible to remove spacing between words using formula

Topic Labels: Formulas
Solved
Jump to Solution
4900 2
cancel
Showing results for 
Search instead for 
Did you mean: 

is it possible to remove spacing between words using formula

1 Solution

Accepted Solutions

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

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: