Help converting a word doc to an Excel file.

Francesca

(452 posts) Send PM | Profile | Ignore

Mon Dec-20-04 05:16 PM
Original message

Help converting a word doc to an Excel file.

I have converted the text to a table and saved as a RIch text file and then opened in Excel and its filled with extra symbols in every field... I have a large word document that I must get into an Excel file and am about to rip my hair out... Forgive my ignorance and help me someone...please...

Printer Friendly | Permalink | | Top

democracyindanger

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-20-04 05:28 PM
Response to Original message

1. Try saving as plain text

or not converting the Word text into a table before importing into Excel. Simply put, leave the data as raw as possible, and futz with it in Excel.

It's difficult to give more assistance without a little more detail. What kind of data--numerical, etc.--are you trying to import from Word?

Printer Friendly | Permalink | | Top

Francesca

(452 posts) Send PM | Profile | Ignore

Mon Dec-20-04 05:51 PM
Response to Reply #1

2. Its a lot listing of an auction catalogue

basically has a numbered list like this

1 Chippendale blah blah blah
2 Oil on canvas blah blah blah
3 Folk art blah blah blah

after the numbers there is a tab to separate the numbers from the text and other than the tab there is no other formatting...
thank you in advance

Printer Friendly | Permalink | | Top

democracyindanger

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-20-04 06:03 PM
Response to Reply #2

3. have you tried

selecting the entire Word document->copy->go to Excel, select the columns that you want to paste into->paste

seems like the easiest way to do it, especially if you want to keep the table you drew in word.

Printer Friendly | Permalink | | Top

welshTerrier2

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-20-04 07:28 PM
Response to Original message

4. got it to work easily without the table ...

i tried inputting your data into Word using only tabs between the columns and then saving the file out as a .txt file (not an rtf) ...

then i opened Excel, an clicked file/open ... i chose the .txt file i created and it asked me to choose the delimeter i used ... i told it to use a "tab" delimeter and it then was able to build the excel spreadsheet with the 3 columns ...

i think the "word table" is embedding all sorts of hidden characters ... you might be better off sticking to a tab delimeter and getting rid of the Word table ...

Printer Friendly | Permalink | | Top

Francesca

(452 posts) Send PM | Profile | Ignore

Mon Dec-20-04 09:00 PM
Response to Reply #4

5. thank you thank you!!!!!!!!!!

this is perfect!!!
My regards.

Printer Friendly | Permalink | | Top

welshTerrier2

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-20-04 10:08 PM
Response to Reply #5

6. glad it worked out ...

who's the auction for? i've written some very customized auction software for mrs. wt2's wine auction that she runs for her non-profit every year ...

i've been thinking of developing a more commercial version as a product i could sell ... does your event use software to generate invoices ??

Printer Friendly | Permalink | | Top

Francesca

(452 posts) Send PM | Profile | Ignore

Tue Dec-21-04 09:10 AM
Response to Reply #6

7. Hi, the auction house is The Cobbs Auctioneers

you can see our website at www.thecobbs.com ... I married one of the Cobbs. I do all the prepress work (all the ads and catalogs) and created the website.. I am self taught however and really need help on occasion.. right now we are using an auction management program running on a UNIX based system to clerk the sales and generate invoices..

Printer Friendly | Permalink | | Top

DU AdBot (1000+ posts)

Wed Apr 24th 2024, 08:20 PM
Response to Original message

Advertisements [?]

Top

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators

Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.