Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to I get a total word count in Excel?
Is there a command to obtain a total word count in Excel spreadsheets similar
to getting a word count in Word documents? This is required to submit language translation requests. Thanks, |
#2
|
|||
|
|||
From Chip
Sub AAA() Dim WordCount As Long Dim Rng As Range Dim S As String Dim N As Long For Each Rng In ActiveSheet.UsedRange.Cells S = Rng.Text N = 0 If S < "" Then N = Len(S) - Len(Replace(S, " ", "")) + 1 End If WordCount = WordCount + N Next Rng MsgBox WordCount End Sub -- -- Don Guillett SalesAid Software "JK" wrote in message ... Is there a command to obtain a total word count in Excel spreadsheets similar to getting a word count in Word documents? This is required to submit language translation requests. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word to excel, excel to word | Excel Discussion (Misc queries) | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Copying Excel object back into Excel from Word | Excel Discussion (Misc queries) | |||
Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) |