Sep 18 2021 09:10 AM
hey everybody
can someone help me with Formula or function to find the number of values inside the cell
like the example below
note\
ms excel 2016
windows 10
Sep 18 2021 09:39 AM
SolutionSep 18 2021 09:47 AM
Sep 18 2021 11:50 AM
I am not suggesting that you need to do this but, out of curiosity, I tried Charles Williams's Fast Excel add-in which has functions to process regular expressions.
Having extracted the strings, I simply counted them
= Rgx.MID(@cellValue, "H/\d*",0)
= COUNTA(Rgx.MID(@cellValue, "H/\d*",0))
The regular expression was set the return any string that starts with "H/" and continues with an arbitrary number of digits.
Sep 18 2021 04:25 PM
Sep 18 2021 09:39 AM
Solution