Merge Word into Excel

[TheTempestSonata]

So I have a list of things in Word... About 12 pages that need to be put into an Excel Document. Is there an easier way to do this than copy / paste it?

[Joel]

What's wrong with the copy/paste?

[TheTempestSonata]

I have about 400 data fields I need to insert into separate cells.

EDIT: 412 lines with 4 data fields in each, so 1648 copy/pastes. My manager likes Word because she can't figure out Excel... so when she imports the files from our database, she imports them as an .rtf instead of an xls. I tried to get her to just do the XLS, but she refuses to do it that way... Now I have to make a "Manageable table" from the data... which requires a spreadsheet...

By the way - What's wrong with only answering if you actually have an answer?

[Manish]

Maybe it's because you hadn't made it clear what needed to be done exactly? Saying you need to transfer "things" from Excel to Word isn't helpful.

In Word, select all the text, click Insert, click Table, click Convert Text to Table, change the settings in the pop-up box if need be, click Ok. When the table is done, copy and paste into Excel!

[soumyasch]

If things are tab delimited, then just copy pasting the entire thing will put things into their own cells. If not, paste as you normally would. Then use the smart tag that pops up to invoke the text import wizard, and specify how the fields are separated (delimited by some specific characters or are fixed width columns). Using the "Text to Columns" button in the "Data" tab will also give you the same wizard.

[TheTempestSonata]

  Manish said:

Maybe it's because you hadn't made it clear what needed to be done exactly? Saying you need to transfer "things" from Excel to Word isn't helpful.

Then ask me to clarify. A pointless answer is still a pointless answer.

The document was setup like this.

SS# - LastName - FirstName - AcademicYear

That was a Word document, not an Excel document...

I need to get them each into an Excel Document, each field into a different column... 412 times.

Copy and pasting is by far not economical here.. Especially since the document is setup with weird spacing that doesn't allow me to double click without getting all weird formatting and whatnot. The spaces between the fields and hyphens are at a different font size than the rest of it. I need to go in and highlight one field at a time and do it that way. Got through about 40 lines today before I began to lose my mind.

[soumyasch]

Please put a sample of the data, we could be in a better position to clarify. Are each entry on separate line? How are the stuff separated (like tab separated)? Did the author of the document allocate a specific number of characters for each field?

If you just copy/paste into Excel, each line will be in a different row; and if the fields are tab-separated, each field will get its own cell. There is nothing to be done. If not, select all the lines, and start the "Text to Columns" wizard and specify how the fields are separated. It will split the fields into cells according to that.

I have attached screenshots demonstrating it.

[TheTempestSonata]

I did...

The word document is setup like that with spaces and hyphens. the characters are 12 pt font, the spaces are 22pt.

I just tried what I see on your screen and it worked for me. I had no idea that that option was even in there. Thank you. Much obliged.

[Joel]

  TheTempestSonata said:

Then ask me to clarify. A pointless answer is still a pointless answer.

I did ask you to clarify. You just chose to be like this instead of answering nicely. Good luck.

  TheTempestSonata said:

I had no idea that that option was even in there.

Which is why I asked you what was wrong with the c&p. There are many features in Excel that I don't know if you know about, so I ask. Teach me to waste my time next time...