Input large amounts of content (words) into an Excel file?

[davejonesbkk]

Hello,

I am writing content for a list of sites for a client. The client supplied me with the list of sites in an Excel file with separate cells for parts of the content such as intro, FAQ's etc.

The client says he would like the content in the Excel file and due to the large amount (over 1,000 words per sites) I am having a lot of trouble doing this.

Can this be done and if so how?

Thanks,

David

[SamuelT]

Hi,

Excel has a tool for importing data from websites called Web Query. How you do this depends on which version of Excel you have. For starters, here's a link on how to do it in pre-2007 versions:

http://office.microsoft.com/en-us/ex...450851033.aspx

If you're using 2007, either use the in-built Help or Google it.

HTH,

SamuelT

[davejonesbkk]

Thanks for the info but I dont think I explained my situation correctly.

I have a list of sites in an excel file. I then went and wrote the content for each of these websites in MS Word files. After sending the completed content back to the client ion the word files he said he wanted the content actually in the excel file on the cells, like 1 cell for the intro for that site (250 words) another cell for site description (500 words) etc.

My problem is that I am finding it hard to get the content in as there is so much of it and my understanding of excel is that its not meant to have hundreds of words inside the cells. But the client insists on this as he says he has some kind of computer program that reads the data and content from his excel file and auto uploads to each site.

So how can I get all this content into the excel file?

[Rubeus_Hagrid]

Hi Dave,

Just copy whole data from word file and paste it into excel sheet.
You can wrap the contents in one cell by using
Format >> Cells >> Alignment and selecting the Wrap text check box.

Please let me know if this has helped you.

[shg]

Be aware that Excel will only display 1k characters in a cell, even if the row is manually resized to show more. The cell can contain up to 32k characters, and they will all show in the formula bar.