Excel Hyperlink to Create Email not displaying & in Subject line

[CTRDevelopments]

I am trying to simplify a system to create card on Kanbanize (this doesnt really matter too much). To do this you can send it an email with specific key words etc and it will then create 'cards' to track progress etc.

I have simplified this to

=HYPERLINK("mailto:email@address.com" & "?subject=" & "1234&Tracker}", "Send email to system")

this should write '1234&Tracker' in the subject line of the email.

However it only writes 1234, the rest of the message is then lost. I have removed the & and everything works correctly, but I need it to write the &

I have also tried popping the & into a cell but this still doesnt work

Is there some way of making it write the & in the email subject?

Cheers

 

[GWteB]

How about ...

=HYPERLINK("mailto:email@address.com?subject=1234%26Tracker", "Send email to system")

 

[CTRDevelopments]

that seems to work, many thanks

 

[GWteB]

Glad to help and thanks for letting me know.