Picking figures out of a cell

V

Vince

Hello everyone,

I have data in a single cell that looks like this: 140x40x200
I want to be able to have an adjacent cell pick/extract the 200 value

Is there a simple way, without resorting to a macro?

Thanks
 
G

Gary''s Student

If the final set of digits is always a three digit number, then:
=RIGHT(A1,3)*1
if not, then use Text to Columns
 
G

Gary''s Student

If you are will to use a UDF, this is only a one-liner:

Function last_number(r As Range) As Long
last_number = Split(r.Value, "x")(2)
End Function
 
Top