Excel Replace text with special character in Excel data

P

pStoneham

Joined
Feb 5, 2007
Messages
3
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace text with special character? 0
Excel Replace with line break (Excel for Mac) 0
Copying a table from Word 5
Wrapping text with line breaks problem 1
Import text to Excel 2
Drag text file to Excel -- stopped working 5
Odd character display (ASCII 128-159) 1
How to find and replace text in a document with changing variables 2

Top