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

--
Gary's Student


"Vince" wrote:

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