LOOK UP Value

  • Thread starter Thread starter joey
  • Start date Start date
J

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.
 
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.
 
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
 
If by "the value" you mean the number after the space, try
=--RIGHT(A1,LEN(A1)-FIND(" ",A1))
 
=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:
 
Back
Top