formula to count text inside a cell

rjplante

Well-known Member
Joined
Oct 31, 2008
Messages
574
Office Version
  1. 365
Platform
  1. Windows
I have a spreadsheet that has three cells merged vertically. In this cell I enter six different letter codes to help me track performance instances. These are "A+", "A-", "m+", "m-", "+", and "-". Each of these are separated by a space within the cell. I would like to have six different cells off to the right to count the number of occurrences of each one inside the cell. How many "+" responses, how many "m-" responses, etc. Is there a formula that will allow me to count each item? Do I have to use commas in the cell to separate my entries? I have been searching online and trying various formula iterations, but I can't seem to find one that will do what I need.

Thanks for the help.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
How about


Book1
ABCDEFGHI
6"A+", "A-", "m+", "m-", "+", "-"A+A-m+m-+-
7111133
8
9
End
Cell Formulas
RangeFormula
D7=(LEN($A$6)-LEN(SUBSTITUTE($A$6,D6,"")))/LEN(D6)
 
Upvote 0
Perfect!! Thanks for the quick response. Works exactly as I need it to.
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top