LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Importing Word Data from Form Field with Line Breaks

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Word cell containing line breaks (soft returns) to Excel Nancy Vazquez Excel Discussion (Misc queries) 0 April 1st 09 08:00 PM
Embedded Word doc containing text form field thosmo1 Excel Discussion (Misc queries) 2 May 4th 07 02:37 PM
I want to copy cell from word that includes line breaks to excel sueCBA Excel Discussion (Misc queries) 1 July 12th 06 05:10 PM
word form field info gnome88 Excel Programming 0 July 27th 05 08:46 PM
Compile/Analyze Word Form Field data from multiple forms? jgundel Excel Discussion (Misc queries) 3 July 14th 05 02:54 AM


All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"