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 :
Text String count within a Cell Show Text String count within a Cell Issue Solution Note Issue 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....
[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...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[VBA] Deleting a word in a range of cell Show[VBA] Deleting a word in a range of cell In the case you want to delete a word in a sentence, just create a small macro that removes the word. But it will become difficult when you have word like, for example, "Theword" or "THEWORD" or...
Download Broadcam Streaming Video Server ShowBroadCam is a free video streaming server which allows you to broadcast lives or pre-recorded videos on internet. Your customer can watch your video stream live with their default multimedia player on any computer. BroadCam deals with video and...
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...
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...
Hyperlinks ShowIntroduction to anchors Hypertext links or hyperlinks (anchors) are HTML elements that, when clicked on, enable readers to visit a new address. Hyperlinked text is underlined by default. Hyperlinks are what connect web pages to one another. They...

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