Search : in
By :

Text String count within a Cell

Last answer on Nov 4, 2009 1:31:41 am GMT GRA, on Feb 17, 2009 1:01:00 pm GMT 
 Report this message to moderators

Hello,
I have number of records (see below) and want to know if I can use a function to count the number of records that contain a specific text string within each cell entry?.

e.g. records could be

FND Short Job Outcome.5000000\.00
FND Sustained Outcome.5000000\.00
.5000000\.00
.5000000\.00


I need a function to locate the text string "Outcome" and return a value of (in this case) = 2 records from the 4 entries.

Is this possible please?

Thanks,
GRA

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Text String count within a Cell » in :
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
How to capture streaming videos from the Internet ShowHow to capture streaming videos from the Internet Download-helper Websites Firefox extension Commercial softwares Info Many websites like YouTube use a Flash Video format that enables highly-compressed streaming video to effectively...
Counter Strike –Personalize skins weapons for CS 1.6 ShowCounter Strike – Personalize skins weapons for CS 1.6 This tutorial has for purpose to show you how to change the skins of weapons for CS 1.6 Note that the skins weapons have the options but with changes of visual aspects in size,...
Structure tags ShowTags can be divided into two groups: Those which change the structure of the page, and those which change the text style. Structure tags include header tags, paragraph tags, list tags, and more. Attributes The following attributes are placed within...
Spreadsheet - Text Operators ShowConcatenation Operator Spreadsheets generally use an oeprator, called a concatenation operator , that allows two text values to be added together. The concatenation operator, written as &, is used as follows: In the above example, the cell...
Linux - The Vi editor ShowIntroduction to Vi Despite its very limited ergonomics, Vi i is one of the most popular text editors texte under Unix type systems (with Emacs and pico). Under Linux, there is a free version of Vi called Vim (Vi Improved). Vi (pronounced vee-eye)...
Ask your question Reply

1

aquarelle, on Feb 17, 2009 8:26:36 pm GMT
  • +1

Hello,
I supposed you had put your data in column A and Row 1 to 4 : 

                    A
1   FND Short Job Outcome.5000000\.00
2   FND Sustained Outcome.5000000\.00
3   .5000000\.00
4   .5000000\.00


The formula is : =COUNTIF(A1:A4;"*Outcome*")

Best regards "Pour trouver une solution � ses probl�mes, il faut s'en donner la peine."

   
Reply to aquarelle

2

 mohit, on Nov 4, 2009 1:31:41 am GMT

Hi,

Can you please let me know if there is a way where a particular text string can be counted within a value of a cell itself.

For example: A cell contains AAAABBBCCCAAA and I need to calculate occurrences of alphabet 'A' in this particular cell.

   
Reply to mohit
Ask your question Reply
They need your help