I am importing web form data as a delimited text string and one of the pieces of data is textarea narrative, which may contain multiple paragraphs. On the web page I processed the text narrative to replace the paragraph breaks with '~~' so it could be imported into Excel as a single delimited cell. But now I cannot figure out how to restore the paragraph breaks. I figure a simple macro should do it but I can't seem to figure out how to write it. Any ideas?
Thank you!
Thank you!