Insert characters in spaces within cell ???

[travelmadness]

I have a long list of words that are appended to the end of a url,
something like this: (one url per cell)

http://www.website.com/default&word word word
http://www.website.com/default&word word
http://www.website.com/default&word word word
http://www.website.com/default&word word word word

I need to put "+" symbols in all spaces between the words, so it will
look like this:

http://www.website.com/default&word+word+word
http://www.website.com/default&word+word
http://www.website.com/default&word+word+word
http://www.website.com/default&word+word+word+word

I'm not sure how to do this, since all the words are different
lengths... is there a formula or something to fill spaces with
characters, or somehting like that???

 

[Frank Kabel]

Hi
try
=SUBSTITUTE(A1," ","+")
in a helper column. Or to create a hyperlink you may use
=HYPERLINK(SUBSTITUTE(A1," ","+") )

 

[travelmadness]

Thank you that worked perfectly

 

[David McRitchie]

If these are constants. Couldn't you just use
Ctrl+H
replace: (single space)
by: +

and be done with it.