word count in Excel
how to count words in excell?
formula provided by F1 Excel help doesn't work, the cell showing the text of the formula I made sure there are no circular references (formula cell and the range it was to calculate are mutually exclusive). |
HI,
for word count in a cell try this =len(cell ref) or count the no. of unblank cell try this =count(rer) "Help Needed 2" wrote: how to count words in excell? formula provided by F1 Excel help doesn't work, the cell showing the text of the formula I made sure there are no circular references (formula cell and the range it was to calculate are mutually exclusive). |
Good morning Anirudh Chip Pearson has a useful routine to take care of this he http://www.cpearson.com/excel/WordCount.htm HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=472898 |
Here is a free tool to count words in Excel:
http://www.montereylanguages.com/exc...free-tool.html It counts the number of words in Excel files, also allows to exclude numbers (like years or dollar amounts) from the word count. |
All times are GMT +1. The time now is 05:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com