How do I get a word count in Excel XP
 

hi nadine
(is it nadine F? you a Greek translator? maybe i know you!)

as another poster said, indeed, excel is set up for numbers, not words. yet
in the translation business, people use it for questionnaires and other
applications that need summary results/responses tabulated.

the easiest way i have come up with for an excel wordcount by selected
columns (not by the entire spreadsheet) is this:

1. open a new word document.
2. go back to the excel sheet you're working with.
3. select entire target column by clicking its top header (A, B, C ,...).
column turns gray and the dotted frame starts blinking.
3. copy it (Ctl+C).
4. return to word document and paste the target column (Ctl+V) there.
5. switch back to excel and do the same with the rest of the
tabs/spreadsheets listed at bottom of page, copying and pasting your target
columns back into word document.
6. when done, click on MS Word's wordcount feature (ToolsWordcount) to get
the total wordcount.

good luck
Mike




"Nadine" wrote:

I am translating and need a word count.