LOOK UP Value

[joey]

Hi guys! Has anyone had an idea how to or what is the formula that can be
used to get the value from a sentence in a worksheet column?
example:
abcd 100
abcdef 10
abcdefgh 200

I just wanted to get the value of each data in a row.
I hope someone can help me.
Thank you guys in advance.

 

[Eduardo]

Hi
try

=TRIM(RIGHT(A1,FIND("",A1)+2))

 

[JLatham]

This works for your sample data where the number follows the one and only
space in the 'sentence':
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
returns the right portion as text
=VALUE(RIGHT(A1,LEN(A1)-FIND(" ",A1)))
actually returns the right portion as a number.

 

[Pete_UK]

If you only have one space then you can use this:

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

assuming your data is in A1.

Hope this helps.

Pete

 

[David Biddulph]

If by "the value" you mean the number after the space, try
=--RIGHT(A1,LEN(A1)-FIND(" ",A1))

 

[Stefi]

=LOOKUP(6.022*10^23,--LEFT(C11,ROW(INDIRECT("1:"&LEN(C11)))))

extracts numeric value from the right hand side of C11.

--
Regards!
Stefi



„joey†ezt írta: