google sheets - Pre filled form and paragraph data

Question

I have created a pre filled form which I can email. Works with this code...

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE('Form Link'!$A$1,"ANS1",A2),"ANS2",B2),"ANS3",C2)

Where ANS1, ANS2, ANS3 are replace by contents of cells A2, B2 and C2 respectively.

All works well until one of my fields, say B2, contains data from a paragraph rather than from a short text. The carriage return character at the end of each line in B2 messes up the resulting link.

How can I get carriage returns (enter) into my link?

question from:https://stackoverflow.com/questions/66061815/pre-filled-form-and-paragraph-data

Answer 1

Waitting for answers