G
Guest
Is there a formula which would allow you to count the number of characters
within a cell which match a certain criteria? FIND will tell you the first
instance of a character or group of characters. LEN will tell you the count
of all characters in a cell.
What I need is something like this:
FORMULA("Betty Crocker Fruit By The Foot Assorted Fruit Roll Fruit Snact 1ct
0.5oz", " ") = 12, because there are 12 spaces in the text.
Alternatively, is there some way to make FIND work backwards and instead of
telling you the first instance of a character, have it tell you the last
instance?
My problem is I am trying to get the "1ct" out of the above example, but the
character count and number of spaces varies with each cell.
Thanks for the advice,
Jane
within a cell which match a certain criteria? FIND will tell you the first
instance of a character or group of characters. LEN will tell you the count
of all characters in a cell.
What I need is something like this:
FORMULA("Betty Crocker Fruit By The Foot Assorted Fruit Roll Fruit Snact 1ct
0.5oz", " ") = 12, because there are 12 spaces in the text.
Alternatively, is there some way to make FIND work backwards and instead of
telling you the first instance of a character, have it tell you the last
instance?
My problem is I am trying to get the "1ct" out of the above example, but the
character count and number of spaces varies with each cell.
Thanks for the advice,
Jane