Give this a try too:
=SUM(IFERROR(1*TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"-",","),",",REPT(" ",99)),{1,3,5,7,9,11,13,15,17}*99,99)),0))
g1,b1,a1 what do I need to do to show a total of 3 for this example? Your help is much appreciated |
XOR LX,
I prefer Yuengling Lager, Yuengling & Son is the oldest operating brewing company in the United States, established in 1829.
I have not had a chance to try Yorkshire ale. But, if I can find it - look out
Thanks for this formula. i have been trying to adapt it so that i can use it on a similar all be it smaller string like this;
g1,b1,a1
what do I need to do to show a total of 3 for this example?
Your help is much appreciated
<tbody>
</tbody>