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

Removing spaces in a line of text

Topic Labels: Formulas
1135 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I need help in writing a formula to remove spaces from a URL.
This specific line of text is already pieced together using a formula:

CONCATENATE(“Potential Partner ApplicationStage 2”,{Auto #},"&organization=",{Organization},"&website=",{Website},"&name=",{Name},"&email=",{Email})

which outputs →

Potential Partner ApplicationStage 2 Bottle (75)&website=http://www.lovebottle.com/&name=Kelly Boslow &email=

However there are spaces within this that need to be removed in order to properly use the link.

Can I get someone to help with this?

3 Replies 3

If you’re trying to create a URL, you should probably be using the ENCODE_URL_COMPONENT function, which does the URL encoding for you.

Sorry that didnt work, it created a confusing URL that didn’t do anything in google.

If you just want to substitute spaces with nothing, then you would just use the SUBSTITUTE function like this:

SUBSTITUTE({String of Text}," ","")