Extract a specific word from cells and count
Solved/Closed
Related:
- Extract a specific word from cells and count
- Extract a specific data from a cell ✓ - Forum - Office Software
- Excel formula to find a specific word in a cell ✓ - Forum - Word
- Copy row if cell contains specific word ✓ - Forum - Excel
- Pop up message in excel if a specific word is entered into a cell ✓ - Forum - Excel
- IF-Then statement to copy rows ✓ - Forum - Excel
1 reply
venkat1926
Jul 13, 2010 at 07:01 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jul 13, 2010 at 07:01 AM
try this
=COUNTIF(A1:A6,"*sap*")
note the asterisk signs.
=COUNTIF(A1:A6,"*sap*")
note the asterisk signs.
Jul 13, 2010 at 07:35 AM
Worked like a charm. Thank you for providing me this solution!