Hello,
I have 3 scenarios of strings like below
P(23) D(2) O(3)
Y(24) DOR(3) O(2)
YM(23) DOR1(3) O(3)
Goal is to create a formula to capture number in O for diff string examples!! and split and sum all numbers in a diff column .
Assistance is greatly appreciated.
Thank you
I have 3 scenarios of strings like below
P(23) D(2) O(3)
Y(24) DOR(3) O(2)
YM(23) DOR1(3) O(3)
Goal is to create a formula to capture number in O for diff string examples!! and split and sum all numbers in a diff column .
Assistance is greatly appreciated.
Thank you