Extract numbers - exact values?

[ljubo_gr]

Hello dear MrExcel's

How to extract value from right, from an aray of data?

CMR: 30.501 litres, rest 11.000 for Barack Obama.

Cmr:31.700L but 5000 goes from R-7 to John Kerry.

cmr: 30000 L rest goes 500 to WhiteHouse from R-7

<tbody>
</tbody>

tHESE are only three examples, three rows of data, they are different but simmilar, How to extract 11000 5000 and 500 and Sum that?
This is impossible 'cause they are different, one start with "rest 11000", second starts with "but", third with "goes"....If i extract numbers i get 3050111000 3170050007......
Any help would be kindly appreciated, Thanks!

 

[ljubo_gr]

tHANKS Peter.
Pattern is: FIND("cmr") from left, FIND("R5to12") from right. CMR usually have 5 to 7 numbers(33333, 33.333, " "33.333" ")

 

[Peter_SSs]

tHANKS Peter.
Pattern is: FIND("cmr") from left, FIND("R5to12") from right. CMR usually have 5 to 7 numbers(33333, 33.333, " "33.333" ")

That doesn't seem to answer either of my 2 questions:

Are we talking about the original problem in the thread or are we talking about this, which still hasn't been explained clearly:

Also, does every cell start with "CMR" like Extract number (1) in post #11, or can the cells be like Extract number (2) in that post?

 

[ljubo_gr]

CMR: 31.509L, rest of 20500 for Barack obama This not working with Extract (2) formula, I have been using first formula wich is great formula except when is R-7 at end, then It shows that 7 as result.

 

[Rick Rothstein]

CMR: 31.509L, rest of 20500 for Barack obama This not working with Extract (2) formula, I have been using first formula wich is great formula except when is R-7 at end, then It shows that 7 as result.

Which number do you want from this example... the 31.509 or the 20500 ?

 

[ljubo_gr]

20500 always

Problems when is: CMR12345 rest in R-7 >>>here isn't my number, show me "", R is reservoir
CMR121344 rest 1234 in R-12 >>>>here show me ""
CMR 32322 rest of 12000 goes to Shaquille O'Neal >>>>>>>>here show me 12000

 

[Rick Rothstein]

CMR121344 rest 1234 in R-12 >>>>here show me ""

Why "" and not 1234 ?

 

[ljubo_gr]

Why "" and not 1234 ?

Sorry your majesty, it's nothing""

 

[Rick Rothstein]

Sorry your majesty, it's nothing""

I see it is nothing ""... what I want to know is why is it nothing? What is the "rule" that makes this...

CMR121344 rest 1234 in R-12

nothing but makes this...

MR 32322 rest of 12000 goes to Shaquille O'Neal

1200? I do not see the difference.

 

[ljubo_gr]

I want only litres for Barack obama, shaq ...
Peter's first formula(post#11) could do the job, but having problems with example CMR1213454 rest 1234 in R-7 giving me 7 instead "" 'cause there is no litres for Barack or Shaq

 

[Rick Rothstein]

I want only litres for Barack obama, shaq ...
Peter's first formula(post#11) could do the job, but having problems with example CMR1213454 rest 1234 in R-7 giving me 7 instead "" 'cause there is no litres for Barack or Shaq

Here is what you posted...

CMR121344 rest 1234 in R-12 >>>>here show me ""
CMR 32322 rest of 12000 goes to Shaquille O'Neal >>>>>>>>here show me 12000

Where do litres appear in either one of these? I don't see it, but one is supposed to return nothing "" and the other 12000... why???