artsyangel7
New Member
- Joined
- Aug 28, 2017
- Messages
- 3
Hello! I am looking for an easy way to calculate the sum of numbers present in a long string of text. Our website exports order data in this fashion (product x quantity):
Hot Apple Pie Candle (#010) | x 1; Gma's ******* Candle (#009) | x 1; Fresh Linen Candle (#008) | x 2
For reporting purposes we need to calculate the total number of units on each order. So in the above example it would be 1+1+2=4. I've tried several formulas without much luck so I was hoping someone here might be able to offer some suggestions on how to achieve this. Thank you in advance. Have a nice day!
Hot Apple Pie Candle (#010) | x 1; Gma's ******* Candle (#009) | x 1; Fresh Linen Candle (#008) | x 2
For reporting purposes we need to calculate the total number of units on each order. So in the above example it would be 1+1+2=4. I've tried several formulas without much luck so I was hoping someone here might be able to offer some suggestions on how to achieve this. Thank you in advance. Have a nice day!