Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Exporting Word Form Data into Excel
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. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Exporting Word Form Data into Excel
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. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Converting Word Perfect forms to Word forms | Microsoft Word Help | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
Create a form in excel and word that locks in the user's data so . | Microsoft Word Help | |||
Create a form in excel and word that locks in the user's data so . | Microsoft Word Help |