Count String Occurrence in a Cell
Best Answer
-
Hey @Nazeer Sayyed
See if this will work for you
=(LEN([Status (Delivered)]@row) - LEN(SUBSTITUTE([Status (Delivered)]@row, "Delivered", ""))) / LEN("Delivered")
This is looking at the length (number of characters) of the entire string, subtracts the non "Delivered" characters, which means what is left should be a string length in multiples of the word "Delivered". By dividing by the Delivered length we can see how many multiples were in the original string.
cheers
Answers
-
Hey @Nazeer Sayyed
See if this will work for you
=(LEN([Status (Delivered)]@row) - LEN(SUBSTITUTE([Status (Delivered)]@row, "Delivered", ""))) / LEN("Delivered")
This is looking at the length (number of characters) of the entire string, subtracts the non "Delivered" characters, which means what is left should be a string length in multiples of the word "Delivered". By dividing by the Delivered length we can see how many multiples were in the original string.
cheers
-
Hi KDM,
Thanks much for your quick help. The solution you provides works the way I wanted.
Appreciate your help. 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!