| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
