If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|