strings with newline & symbols

[Snypa]

I need to replace whatever vba uses for newlines (when you press alt+enter in a cell) in a string to "%0A", how can this be done best?

I tried this but it did not work:

 desc = Replace(desc, vbNewLine, "%0A")

 

[Snypa]

    desc = Range("R12").value
    desc = Replace(desc, vbCrLf, "%0A")

 

[Fluff]

Try

desc = Replace(desc, chr(10), "%0A")

 

[Snypa]

Try

desc = Replace(desc, chr(10), "%0A")

That worked, thank you.

Is there a list of the chr numbers? I also need to replace some symbols (the bullet point from outlook) but cannot see a chr number for it.

 

[Fluff]

The Chr numbers can be found here ASCII Table - ASCII character codes they are the dec numbers in the first column