LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get a word count in Excel XP PGiessler Excel Discussion (Misc queries) 3 April 5th 12 11:24 PM
word count in Excel Help Needed 2 Excel Worksheet Functions 3 April 5th 12 08:05 PM
Need Excel count of 1 word if found in multi-word cells of column Function_Challenged Excel Worksheet Functions 1 August 27th 09 12:08 AM
How to count the frequency of each word in Excel deedee Excel Discussion (Misc queries) 3 January 24th 09 12:35 PM
How to I get a total word count in Excel? JK Excel Discussion (Misc queries) 1 July 6th 05 04:19 PM


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"