Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

EXCEL to WORD copying cell contents


(!)

daysky's Avatar
daysky daysky is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Nov 2010
03-Nov-2010, 06:13 PM #1
EXCEL to WORD copying cell contents
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.
Ent's Avatar
Ent   (Josiah) Ent is offline Ent is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 5,233 posts.
 
Join Date: Apr 2009
Location: United Kingdom
Experience: Intermediate
04-Nov-2010, 03:49 AM #2
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.
Ent's Avatar
Ent   (Josiah) Ent is offline Ent is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 5,233 posts.
 
Join Date: Apr 2009
Location: United Kingdom
Experience: Intermediate
04-Nov-2010, 12:41 PM #3
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
File Type: zip SSCONV.zip (25.0 KB, 20 views)
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
04-Nov-2010, 12:48 PM #4
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.
daysky's Avatar
daysky daysky is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Nov 2010
08-Nov-2010, 07:41 PM #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
daysky's Avatar
daysky daysky is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Nov 2010
08-Nov-2010, 07:42 PM #6
i dont know what CSV is....
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
08-Nov-2010, 10:49 PM #7
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.
Ent's Avatar
Ent   (Josiah) Ent is offline Ent is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 5,233 posts.
 
Join Date: Apr 2009
Location: United Kingdom
Experience: Intermediate
09-Nov-2010, 12:19 PM #8
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.
daysky's Avatar
daysky daysky is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Nov 2010
09-Nov-2010, 06:29 PM #9
It says that the file is password protected????
Ent's Avatar
Ent   (Josiah) Ent is offline Ent is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 5,233 posts.
 
Join Date: Apr 2009
Location: United Kingdom
Experience: Intermediate
09-Nov-2010, 06:35 PM #10
Odd. I'll try and re-upload it. Sorry. If you do have trouble then can you post your excel sheet.
Attached Files
File Type: zip SSCONV.zip (25.1 KB, 17 views)
daysky's Avatar
daysky daysky is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Nov 2010
09-Nov-2010, 07:02 PM #11
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!
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


Similar Threads
Title Thread Starter Forum Replies Last Post
Solved: Excel Macro Dropdown Menu Cell Contents xpertus Business Applications 36 08-Feb-2010 02:21 PM
Excel Marco Dropdown Menu Cell Contents xpertus Software Development 1 01-Feb-2010 06:37 PM
Excel Cell Contents Disappearing Sunny410 Business Applications 0 07-Jul-2009 11:43 PM
Copy excel to word without grid duckwinter Business Applications 4 05-Jul-2009 07:23 PM
Excel to Word document Stillasfan Software Development 2 27-Apr-2009 01:53 PM

WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑