OK. Sorry for the long title and hope someone can help. I will explain best I can.
Basically I need all the gaps in my string to be replaced with %20.
I need to achieve this either in the original excel document where the string is created (best option)
Or when the string is mail-merged in Word. But there is a secondary issue when the text, including the string is cut and pasted into Messages on my Mac

Below I will try and explain exactly what Im doing & trying to do

I have a database in Excel. A formula has been made so all the relevant information in the database is combined into a string that I want to send as a Text Message once merged to some additional text in Word

eg: The String created in Excel from fields is:
https://ourcompanyname.typeform.com/to/IKwV2S?&name=MR Fred&date=121216&our_ref=11134&reg=PPP 123&driver=Mick Smith

When I mail merg the string into a Word document the underlining disappears (but I can create a hyper link)


eg:

Dear Sir, please click the link below on your phone

https://ourcompanyname.typeform.com/to/IAwQ3R?&name=MR Fred&date=121216&our_ref=11134&reg=PPP 123&driver=Mick Smith

BECOMES

Dear Sir please click the link below on your phone

https://ourcompanyname.typeform.com/to/IAwQ3R?&name=MR Fred&date=121216&our_ref=11134&reg=PPP 123&driver=Mick Smith

But when this is pasted into Messages on my Mac it comes out like this:

Dear Sir please click the link below on your phone

https://ourcompanyname.typeform.com/to/IAwQ3R?&name=MR Fred&date=121216&our_ref=11134&reg=PPP 123&driver=Mick Smith
<https://ourcompanyname.typeform.com/...3R?&name=MR%20 Fred&date=121216&our_ref=11134&reg=PPP%20123&drive r=Mick%20Smith>

So I have to delete: https://ourcompanyname.typeform.com/to/IAwQ3R?&name=MR Fred&date=121216&our_ref=11134&reg=PPP 123&driver=Mick Smith

So Im left with

Dear Sir please click the link below on your phone

<https://ourcompanyname.typeform.com/...3R?&name=MR%20 Fred&date=121216&our_ref=11134&reg=PPP%20123&drive r=Mick%20Smith>