Google Spreadsheet Post #1374
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 19, 2013
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 19, 2013
user Sandy Joe (http://productforums.google.com/forum/?zx=x8ts4l41ygu7#!category-topic/docs/spreadsheets/DXbul9-gIYY)
How can I count the occurrences across a range of cells of a word within a paragraph
I would appreciate any help on how to do this since I've been racking my brains and searching like crazy on an easy way to accomplish this. Basically, I have multiple columns of data where each cell contains a paragraph of text. I would like to get a count of the number of occurrences for a specific string contained within the paragraph. For example, if the string I'm looking for is "class" then for a defined range of cells, I would like to get a count of how many times this string appears. For any given cell, this string could appear multiple times.
--------------------------------------------------------------------------------------------------------------------------------------------------
How can I count the occurrences across a range of cells of a word within a paragraph
I would appreciate any help on how to do this since I've been racking my brains and searching like crazy on an easy way to accomplish this. Basically, I have multiple columns of data where each cell contains a paragraph of text. I would like to get a count of the number of occurrences for a specific string contained within the paragraph. For example, if the string I'm looking for is "class" then for a defined range of cells, I would like to get a count of how many times this string appears. For any given cell, this string could appear multiple times.
--------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment