Importing Word Data from Form Field with Line Breaks

D

DonO

I created a form for users to fill out in Word, and saved it as a
template.

Now when I want the user to fill it out, I set it up to save the data
as text (Tools > Options > Save)

If the user types something like...

-------------------------
Some text
More text
-------------------------

Where they've hit return and created a new line, when I open the .txt
file in excel I get the "More text" line on a new line in column A.

How can I modify either Word to escape the new line, or Excel to wrap
it or igore the new line?

Thanks for any help. I'm obviously not a Word/Excel guru so I
appreciate any guidance.

D.
 

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

Top