Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
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" wrote in message ... 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? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
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: 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" wrote in message ... 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? |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Formula
Word doesn't have that capability. You might be able to get something
acceptable using a macro, although, dynamic updating would be a tall order. -- Herb Tyson MS MVP Author of the Word 2007 Bible Blog: http://word2007bible.herbtyson.com Web: http://www.herbtyson.com "Neil" wrote in message ... 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: 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" wrote in message ... 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula | Tables | |||
what is a formula ? | Microsoft Word Help | |||
how to align caption of formula right whereas formula itself left | Microsoft Word Help | |||
Formula help? | Microsoft Word Help | |||
Formula help? | Page Layout |