View Single Post
  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Dazed&Confused
 
Posts: n/a
Default Exporting Word Form Data into Excel

Thanks for the help, Ill give it a try.

"Shauna Kelly" wrote:

Hi

In Excel, have you tried Data Text to Columns? That might solve the
problem. If you need further help with that, I'd suggest you ask in an Excel
newsgroup.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word


"Dazed&Confused" wrote in message
...
Currently trying to export form data from MS Word into MS Excel which is
really quite simple, however... all data exported into the plain text file
appears on one line. This means that when I import it into Excel it all
appears on one line as well.

Is there a way in which I can export the data so that when it reaches a
certain point in the form it exports the data onto a new line in the plain
text file?

This would mean that when I import it into Excel the next lot of form data
appears on the row beneath and so on.

Any help would be appreciated

Thanks.