Question
I want to use excel to count a special word in a string in a excel cell. For example, one cell is: [{age: 42, 'gender':
I want to use excel to count a special word in a string in a excel cell. For example, one cell is:
[{age: 42, 'gender': 'Male', 'Rectangle': {'left': 132}}, {age: 48, 'gender': 'Male', Rectangle': {'left': 426}}, {age: 27, 'gender': 'Male', 'Rectangle': {'left': 275}}]
I want to count the number of word "age". The answer in upper example is 3.
Imagin the next cell is [{'age': 44, 'gender': 'Male', 'Rectangle': {'left': 134}}. Number of word "age" in this cell is one.
I want to do this for all the cells in a column. Could you please help me which formula I can use to find the number of word "age" in excel?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started