Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Removing spaces in a line of text

Topic Labels: Formulas
2565 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Clair_Arthur
4 - Data Explorer
4 - Data Explorer

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.

Clair_Arthur
4 - Data Explorer
4 - Data Explorer

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