Pasting excel into word

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?
 
S

SpreadsheetBrian

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

pasting content copied from nonadajacent cells 1
How to use Windows command within Excel macros 2
Importing a Text File Into 1 Column 3
Copy-Paste Chart into Word from Excel 2007 3
Copy and Paste cells limitation 4
How do you paste a list of bulleted text from a word doc. into exc 2
pasting linked excel cell and maintaining formatting no matter wha 1
Some charts won't copy properly from Excel 2007 6

Top