1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

EXCEL to WORD copying cell contents

Discussion in 'Business Applications' started by daysky, Nov 3, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. daysky

    daysky Thread Starter

    Joined:
    Nov 3, 2010
    Messages:
    5
    I have an excel spreadsheet. I would like to copy the contents of the table to word but I do not want it to be in a table on the word document. Even hiding gridlines does not work because I still cannot maniputate information in the cells. Is there any way to make the table inactive?

    For example:
    With gridlines hidden it looks like

    Blah Blah Blah Blah

    and I want it to look like
    blah
    blah
    blah blah

    i could cut each cell but that would take forever because I have 6 columns
    and 160 rows.
     
  2. Ent

    Ent Josiah Trusted Advisor

    Joined:
    Apr 11, 2009
    Messages:
    5,410
    Just a quick pointer, if you save it as a CSV file you won't have a table. Open that with notepad and you'll doubtless find it easier to get rid of quotes and commas. If not it would probably be possible to craft a little program to do it for you, but I'm going to school now, so I can't personally do that for the next 7 hours.
     
  3. Ent

    Ent Josiah Trusted Advisor

    Joined:
    Apr 11, 2009
    Messages:
    5,410
    I have attached a tiny program to convert a CSV file to a text file such that every cell is in a new line. I hope it's useful to you.
     

    Attached Files:

  4. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    If each "Blah" means a different cell in Excel, how is Word supposed to know how to rearrange the data without your manual input?
    A little more information might be useful here, please.
     
  5. daysky

    daysky Thread Starter

    Joined:
    Nov 3, 2010
    Messages:
    5
    the excel spreadsheet contains the following columns: name, address, phone number, etc.

    I want the word document to contain a block of information on each side:
    name
    address
    city, state zip

    and the other side:
    home phone
    cell phone
    etc
     
  6. daysky

    daysky Thread Starter

    Joined:
    Nov 3, 2010
    Messages:
    5
    i dont know what CSV is....
     
  7. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    CSV is comma-delimited. Excel should open Ent's file automatically (once you extract it from the zip file) - if it doesn't, open Excel, then change the file type to CSV and look for where you extracted Ent's file.
     
  8. Ent

    Ent Josiah Trusted Advisor

    Joined:
    Apr 11, 2009
    Messages:
    5,410
    Can you attach the sheet in question, and I'll do the conversion for you? If not what you have to do is

    Extract my program to a folder.
    Scan it for viruses. There aren't any, but it's something you should always do.
    Open the spreadsheet.
    Click Save as.
    Save as SSheet.csv in the same folder.
    Run my program.

    Sorry that I wasn't clear the first time.
     
  9. daysky

    daysky Thread Starter

    Joined:
    Nov 3, 2010
    Messages:
    5
    It says that the file is password protected????
     
  10. Ent

    Ent Josiah Trusted Advisor

    Joined:
    Apr 11, 2009
    Messages:
    5,410
    Odd. I'll try and re-upload it. Sorry. If you do have trouble then can you post your excel sheet.
     

    Attached Files:

  11. daysky

    daysky Thread Starter

    Joined:
    Nov 3, 2010
    Messages:
    5
    Okay, thanks to all for the replies... saving it as CSV helped... i was able to cut and paste it into word, then merge cells to be able to manipulate the data. You guys were so helpful... THANKS!:rolleyes:(y)
     
  12. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/960313