|
| View previous topic :: View next topic |
| Author |
Message |
Neil Guest
|
Posted: Wed Dec 19, 2007 9:48 pm Post subject: Formula |
|
|
Hi, I have a word document with a variety of tables in it. I am trying to
count the number of times a string of letters appear. In excel I would simply
select the field and use the countif, but can't do this in word! Can anyone
help please? |
|
| Back to top |
|
 |
Google Sponsor

|
Posted: Wed Dec 19, 2007 9:48 pm Post subject: Advertisement |
|
|
|
|
| Back to top |
|
 |
Herb Tyson [MVP] Guest
|
Posted: Thu Dec 20, 2007 1:03 am Post subject: Re: Formula |
|
|
If you find/replace text with itself Word will report the number of hits.
For example, suppose I'm looking for the number of times that "ABcd" (case
specific) occurs in a file. I can do Find/Replace:
Find: ABcd
Replace with: ABcd
Match case enabled
Replace All
Word will tell you how many it replaced, effectively not changing anything.
If case isn't important, then use ^& as the Replace with: string. ^& is the
special match string for "whatever matched the search". Hence, in this case,
if Word found AbCd or ABCD it would replace it with AbCd or ABCD,
respectively.
--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com
"Neil" <Neil@discussions.microsoft.com> wrote in message
news:76051504-B967-4255-A1B0-2014AAC8F652@microsoft.com...
| Quote: | Hi, I have a word document with a variety of tables in it. I am trying to
count the number of times a string of letters appear. In excel I would
simply
select the field and use the countif, but can't do this in word! Can
anyone
help please?
|
|
|
| Back to top |
|
 |
Neil Guest
|
Posted: Thu Dec 20, 2007 7:48 pm Post subject: Re: Formula |
|
|
thanks for that. I didn't quite explain what I wanted though, what I'd like
is the result shown dynamically in the word document so users can see a
running total of a number of occurances, by the way its office 2003 on XP
"Herb Tyson [MVP]" wrote:
| Quote: | If you find/replace text with itself Word will report the number of hits.
For example, suppose I'm looking for the number of times that "ABcd" (case
specific) occurs in a file. I can do Find/Replace:
Find: ABcd
Replace with: ABcd
Match case enabled
Replace All
Word will tell you how many it replaced, effectively not changing anything.
If case isn't important, then use ^& as the Replace with: string. ^& is the
special match string for "whatever matched the search". Hence, in this case,
if Word found AbCd or ABCD it would replace it with AbCd or ABCD,
respectively.
--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com
"Neil" <Neil@discussions.microsoft.com> wrote in message
news:76051504-B967-4255-A1B0-2014AAC8F652@microsoft.com...
Hi, I have a word document with a variety of tables in it. I am trying to
count the number of times a string of letters appear. In excel I would
simply
select the field and use the countif, but can't do this in word! Can
anyone
help please?
|
|
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|