Logical Test

[Jasa P]

How to resolve this problem? If I have a combination of 125x10 in cell A1, then I just need the number after the "x". So, the value in cell B1 is 10.

Example:
A ____________B
1 125x10 ________10
2 53x5 ___________5
3 4877x150 _____150
4 123x1000 ____ 1000
5 66x49 _________ 49


Please help me, I really need to resolve this problem.
Thank you so much.

Regards

 

[Expiry]

=RIGHT(A1,LEN(A1)-FIND("x",A1,1))

 

[arthurbr]

Perhaps =RIGHT(A1,LEN(A1)-SEARCH("x",A1))

 

[Jon von der Heyden]

Or:
=-LOOKUP(10000,-RIGHT(A1,{1;2;3;4}))

 

[Jasa P]

Thank u so muchhhhh guys.... really.... thanks...

really sorry about the relevant keyword thread title 'cause I'm new here... I just joined this forum about 30minutes ago... sorry for my mistakes... really sorry

This is really great forum... The only place to resolve my problems...

But is it possible to sum the numbers after "x"...?
ex: in cell A1 125x10x10x10 so in cell B1 is =10+10+10=30

Thank u so much.... thank u