get all words in a field and put a "+" symbol between words

[Mountain]

 

 

I am trying to automate a url lookup but the URL requires a "+" symbol between all words.  Is there a calc to do this? There are always different number of words? Don't understand how to do this with more than 2 words. Thanks

 

[doughemi]

Substitute(YourLookupField; " "; "+")

 

Or if the words are a list instead of a sentence:

 

Substitute(YourLookupField; "¶"; "+")

[wlitzau]

You can also use:

 

Substitute(YourLookupField; [" "; "+"] ; ["¶";"+"])