Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get a word count in Excel XP | Excel Discussion (Misc queries) | |||
word count in Excel | Excel Worksheet Functions | |||
Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
How to count the frequency of each word in Excel | Excel Discussion (Misc queries) | |||
How to I get a total word count in Excel? | Excel Discussion (Misc queries) |