|Does the text string "Walsh" appear by itself in the cell or is it a part of a longer string?|
Either way try this, with your data like:
1) Tom Walsh
3) Walsh & Sons
Enter this formula is any cell:
If you have more then ten rows, simply modify the range E1:E10 to suit your needs.
The Star or Asterisk character on either side of the string "Walsh" are
wild card figures and match "any character any number of times".
You should get 4 as an answer.
In your other posts you requested a formula to be used across multiple sheets.
Although you did not mention it in this post, in case that is what you
need then try something like:
There are other ways of doing this, but this is the simplest.
message edited by mmcconaghy