LOOK UP Value
 

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.

LOOK UP Value
 

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.


"joey" wrote:

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.

LOOK UP Value
 

Hi
try

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



"joey" wrote:

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.

LOOK UP Value
 

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


On Dec 14, 12:48*pm, joey wrote:
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.

LOOK UP Value
 

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

"joey" wrote in message
...
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.

LOOK UP Value
 

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

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.