Formula to extract text from a string

Hello,

I'm trying to figure out a formula that will extract part numbers from a description. The problem is some of them have spaces in between the numbers, they aren't all the same length, and some of them contain letters. All the numbers are on the right of the description and happen after a space. Any idea how to write a formula that works for each of the cases in the example below? Thank you.




c2 D2

Small 23456
cleaner GH45676
brush 994 55456 123

Try this formula

Formula:

Please Login or Register  to view this content.

you can try this as well..

Formula:

Please Login or Register  to view this content.

Thanks AlKey. Your formula works for the numbers. However, there are some cases where I need to include letters in front of the numbers.

Ex. cleaner GH45676 should return GH45676

Also, I forgot to include a case where there is a sting of just letters that need to be returned.

Ex. Cleaner GGG should return GGG

Suggestions? Thanks for your help?

choice

=RIGHT(C2;LEN(C2)-FIND(" ";C2))

Thanks AlKey and azumi.

Both =SUBSTITUTE(TRIM(MID(C2,FIND(" ",C2),99))," ","")
and =RIGHT(C2;LEN(C2)-FIND(" ";C2))

work for the example I provided. I apologize, I realize now I wasn't complete in the examples I gave, as I'm finding it doesn't work in the real workbook. Some of the descriptions contain multiple spaces. The one thing that's the same though, is that the part number always comes after the last space. I'd like to return what is shown in column D. Thanks again for your help. This example contains more spaces in the description.

C D (return)
cleaner small 23456 23456
big cleaner GH45676 GH45676
open Brush 994 55456 123 994 55456 123
sample sample Cleaner GGG GGG