PDA

View Full Version : Excel to Word.



Scouse
24-10-2008, 07:21 PM
Hi Folks.
Using Office Suite 2003. Is there a simple way of copying data from an Excel file to a Word file as text? Once it is in Word as text I would put it in a Word table as a small database. Having a mental blockage....... thanks.

Jen
24-10-2008, 07:34 PM
I can't remember the steps for Office 2003, but you want the Word convert text to table tool.

wainuitech
24-10-2008, 08:06 PM
Dont Know if this is what you want or not ---

You can copy the excel Spread sheet into a word document.

In Word click on Insert Excel Spread Sheet Symbol Example (http://www.imagef1.net.nz/files/Excel_1.jpg)

That will insert a blank Spreadsheet that you can grab the bottom right corner and drag to the size you want Example (http://www.imagef1.net.nz/files/Blank.jpg)

Then go to your Spread Sheet, select the cells you want say A1 - D18 ( or what ever cells you have/want ), then copy - Go back to your Word Document Select Cell A1 and in the spread sheet Paste back in.Copied (http://www.imagef1.net.nz/files/Copied.jpg) then Click out side Table / Save it (http://www.imagef1.net.nz/files/Save_it.jpg) and theres your table. If you double click it, it will turn back into a working spreadsheet you can alter.

Scouse
24-10-2008, 08:41 PM
Hi Jen - Wainui*. Cracked it thanks and all is well. Just a matter of engaging the old brain properly. Appreciate your help. :)

pctek
25-10-2008, 07:34 AM
Or just a simple copy, and paste as text will do.