Computer Forum Forum Index
Register  FAQ Profile Log in to check your private messages Log in Register 

Formula

 
Post new topic   Reply to topic    Computer Forum Forum Index -> microsoft word tables
View previous topic :: View next topic  
Author Message
Neil
Guest





PostPosted: Wed Dec 19, 2007 9:48 pm    Post subject: Formula Reply with 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
Google
Sponsor





PostPosted: Wed Dec 19, 2007 9:48 pm    Post subject: Advertisement

Back to top
Herb Tyson [MVP]
Guest





PostPosted: Thu Dec 20, 2007 1:03 am    Post subject: Re: Formula Reply with 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...
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





PostPosted: Thu Dec 20, 2007 7:48 pm    Post subject: Re: Formula Reply with quote

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
Display posts from previous:   
Post new topic   Reply to topic    Computer Forum Forum Index -> microsoft word tables All times are GMT
Page 1 of 1

 
Jump to:  
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
Computer Forum