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

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

--
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

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

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

--
Gary's Student

Thumbs up! Thanks