In Excel I have some informations about products and sum of numbers which comes from cell note. Therefore I need to do all calculation by hands. Example of excel note is below in code. So I need simple regular expression that ignore all data which don't have pcs on end (number) and count them together for example that will be 27500.
So could be somebody be so kind and at least get me right direction....
Code: Select all
plant A
17.5. 8000pcs
platn 9
15.8. 2500pcs
plant s1
15.8. 1500pcs
plant 23
15.8. 1000ks
factory z22
15.8. 500pcs
factory ABC
15.8. 15000pcs