Pasting excel into word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to paste a column from excel into word (2003 version). I can
paste it as unformatted text, but what i really want to do is paste it with
cells separated by commas. Is that possible?
 
I am trying to paste a column from excel into word (2003 version). I can
paste it as unformatted text, but what i really want to do is paste it with
cells separated by commas. Is that possible?
Click to expand...

An easy-ish route would be to save your spreadsheet as a CSV (File >>
SaveAs) and then open the CSV file with notepad and you'll see the
data separated by commas. Copy it out of notepad and into your word
document.

Since you're only interested in a single column, copy the column to a
separate workbook, then paste-special and select the transpose option
to get the column to appear as a row. Then save it as a CSV to get
only the data you're after.

Brian Herbert Withun
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy-Paste Chart into Word from Excel 2007 3
Copy and Paste cells limitation 4
Exporting data in excel to word 1
Why this paste result? 4
Importing a Text File Into 1 Column 3
Copying a table from Word 5
Is Paste Special HTML broken in Excel/Office 2007? 1
Copy/Past from Word-spreadsheet format alignment disregarded 3

Back
Top