Character count in Excel?
Murgi
I receive sometimes jobs where I have to translate sentences in cells while
overwriting the source text.
The Excel file also includes a number of "text boxes".
When I copy the Excel file into MS Word, normal text is copied, but the text
within the text boxes is not.
Is there a way to get a total character count directly in Excel, or is there
a trick to copy everything into MS Word for a proper count?
If this doesn't work, is there some software that will make proper counting
possible?
Sigi
Haluk Skywalker
news:4af56c81facce7f2...@news.secureusenet.com...
> ...
> Is there a way to get a total character count directly in Excel, or is
there
> a trick to copy everything into MS Word for a proper count?
> If this doesn't work, is there some software that will make proper
counting
> possible?
>
> Sigi
>
>
I usually copy and paste to word. If you are billing based on word
count -rather than character count, there is a free utility called
translators abacus (also counts html and some other text). But abacus only
gives word count.
Haluk Skywalker
news:4af56c81facce7f2...@news.secureusenet.com...
Speaking of character count, here is a little set of Word macros that count
multiple files in a folder and generate a total character count report -very
handy for billing purposes.
http://cwf.flower-cards.com/index.php?whichpage=plustools&lang=engb
Ryan Ginstrom
"Haluk Skywalker" <yok.oo...@spam.net> wrote in message news:c413on$2brqqo$1...@ID-201738.news.uni-> Speaking of character count,
here is a little set of Word macros that count
> multiple files in a folder and generate a total character count report -very
> handy for billing purposes.
>
> http://cwf.flower-cards.com/index.php?whichpage=plustools&lang=engb
>
I also have a small macro that counts all the words in an MS-Word file, including words in text boxes. Double-byte characters are
also counted.
http://www.ginstrom.com/software/wordmacros/wordcount.html
--
Regards,
Ryan Ginstrom
Haluk Skywalker
news:c41fgk$2cium3$1...@ID-101276.news.uni-berlin.de...
Excellent. Any tips as to how I can modify these functions/methods so
characters are counted instead of words?
Ryan Ginstrom
"Haluk Skywalker" <yok.oo...@spam.net> wrote in message news:c41li7$2d8hrp$1...@ID-201738.news.uni-berlin.de...
> "Ryan Ginstrom" <gins...@hotmail.com>, iletide ?unu yazd?
> news:c41fgk$2cium3$1...@ID-101276.news.uni-berlin.de...
> including words in text boxes. Double-byte characters are
> > also counted.
> >
> > http://www.ginstrom.com/software/wordmacros/wordcount.html
>
> characters are counted instead of words?
Try it again, I just modified it to count the characters. Now it counts characters, words, and double-byte characters. The
non-Japanese character/word count ends up being the character/word count minus double-byte characters.
--
Regards,
Ryan Ginstrom
Declan Murphy
GITS!
--
"Oh don't give me none more of that Old Janx Spirit/ No, don't you give
me none more of that Old Janx Spirit/ For my head will fly, my tongue
will lie, my eyes will fry and I may die/ Won't you pour me one more of
that sinful Old Janx Spirit"
Ryan Ginstrom
"Declan Murphy" <declan...@hotmail.com> wrote in message news:40650DFC...@hotmail.com...
> > http://www.ginstrom.com/software/wordmacros/wordcount.html
>
> GITS!
You like?
Our company motto:
Ginstrom IT Solutions (GITS) -- You've never had a solution like one delivered by GITS!
--
Regards,
Ryan Ginstrom
Declan Murphy
> "Declan Murphy" <declan...@hotmail.com> wrote in message news:40650DFC...@hotmail.com...
>
>>>http://www.ginstrom.com/software/wordmacros/wordcount.html
>>
>>GITS!
>
> You like?
I love it. Even more than Aichi Security Services.
> Our company motto:
> Ginstrom IT Solutions (GITS) -- You've never had a solution like one delivered by GITS!
How many gits actually work at GITS?
Ryan Ginstrom
"Declan Murphy" <declan...@hotmail.com> wrote in message news:40650FEA...@hotmail.com...
> Ryan Ginstrom wrote:
> > Our company motto:
> > Ginstrom IT Solutions (GITS) -- You've never had a solution like one delivered by GITS!
>
> How many gits actually work at GITS?
Technically, we have two employees, but this is really a one-man show. You could call me the head GIT.
--
Regards,
Ryan Ginstrom
Haluk Skywalker
>
> ...
> > Excellent. Any tips as to how I can modify these functions/methods so
> > characters are counted instead of words?
>
> Try it again, I just modified it to count the characters. Now it counts
characters, words, and double-byte characters. The
> non-Japanese character/word count ends up being the character/word count
minus double-byte characters.
>
> --
> Regards,
> Ryan Ginstrom
Thank you very much. That is very nice of you, really.
But I must have done something wrong at installation. After installing the
first version (the one counts words) I had a WordCount macro among the macro
choices displayed upon alt-f8. But, after installing the revised version,
it's gone. Instead, there are 6 macros (more like functions), respectively
WordCount.BodyWordCount, WordCount.ReportWordCount, WordCount.WordCountAll,
WordCount1.BodyWordCount, WordCount1.ReportWordCount. and
WordCount1.WordCountAll.
I think its because I installed it over without uninstalling the first copy.
Anyway the problem is it does not seem right. For instance for following
particular document, your wordcount reports:
10.676 characters in body (which is accurate),
53.380 characters in text boxes (which is way too many), and
10.580 double-byte chars (there shouldn't be any, since the text is in
english).
Doc: http://www.halukaka.com/public/Plasma6.rtf
What am I doing wrong? How do I uninstall and make a clean installation
again?
Ryan Ginstrom
> What am I doing wrong? How do I uninstall and make a clean installation
> again?
I get 10,547 characters, 2,097 words, no words in text boxes.
Why don't you mail me offline at ryang at gol dot com, I'll see if I can get this sorted out.
--
Regards,
Ryan Ginstrom