Changing a specific character type in text string

[cianid]

Hi fellow forumers!

I have the following question/problem i don˙t know how to solve. I have a series of text strings in which there are separations between words. I need to change all separations between words into "%20" in order to create hyperlinks that would work. Is there a formula or macro that can help me do this automatically...i really don`t want to do it manually because there are around 3000 rows of text strings each containing at least 2 words separations.

If am most grateful for your help!

Cianid

[olasa]

Find and Replace (Ctrl+H):
Search for " " and replace with "%20". But exclude the " signs.

Ola Sandström