Home |
Search |
Today's Posts |
#1
|
|||
|
|||
lookup within a cell
I have data in a cell that looks like this ".287/.289". I want to parse out
the data in the next two adjcent cells. The number .287 in the next column and .289 in the column after that. Any ideas? |
#2
|
|||
|
|||
=LEFT(A1,4) and =Right(A1,4)
these cells will be in text format if you need to calculate insert columns with =C1*1 for instance to convert to numbers Greetings from New Zealand Bill K "Parsing data in a cell" <Parsing data in a wrote in message ... I have data in a cell that looks like this ".287/.289". I want to parse out the data in the next two adjcent cells. The number .287 in the next column and .289 in the column after that. Any ideas? |
#3
|
|||
|
|||
One way,
With the data in A1, in B1 =LEFT(A1,FIND("/",A1)-1) in C1 =RIGHT(A1,LEN(A1)-FIND("/",A1)) Regards, Alan "Parsing data in a cell" <Parsing data in a wrote in message ... I have data in a cell that looks like this ".287/.289". I want to parse out the data in the next two adjcent cells. The number .287 in the next column and .289 in the column after that. Any ideas? |
#4
|
|||
|
|||
Try using Data Text to Columns... and use a forward slash as the
deliminator in step 2 and in the 3rd step select the adjacent cell. HTH Sandy "Parsing data in a cell" <Parsing data in a wrote in message ... I have data in a cell that looks like this ".287/.289". I want to parse out the data in the next two adjcent cells. The number .287 in the next column and .289 in the column after that. Any ideas? |
#5
|
|||
|
|||
I was assuming that not all the data would consist of three decimal places,
some would be more or less. Bill is right though, this will return text which is not conducive to reliable calculation. To convert to numbers, change to, =LEFT(A1,FIND("/",A1)-1)*1 and =RIGHT(A1,LEN(A1)-FIND("/",A1))*1 Regards, Alan. "Alan" wrote in message ... One way, With the data in A1, in B1 =LEFT(A1,FIND("/",A1)-1) in C1 =RIGHT(A1,LEN(A1)-FIND("/",A1)) Regards, Alan "Parsing data in a cell" <Parsing data in a wrote in message ... I have data in a cell that looks like this ".287/.289". I want to parse out the data in the next two adjcent cells. The number .287 in the next column and .289 in the column after that. Any ideas? |
#6
|
|||
|
|||
Thanks Sandy
Learning every day. Never worked with the text to columns. Bill K "Sandy Mann" wrote in message ... Try using Data Text to Columns... and use a forward slash as the deliminator in step 2 and in the 3rd step select the adjacent cell. HTH Sandy "Parsing data in a cell" <Parsing data in a wrote in message ... I have data in a cell that looks like this ".287/.289". I want to parse out the data in the next two adjcent cells. The number .287 in the next column and .289 in the column after that. Any ideas? |
#7
|
|||
|
|||
You're welcome Bill.
Learning every day. Aren't we all "Bill Kuunders" wrote in message ... Thanks Sandy Learning every day. Never worked with the text to columns. Bill K "Sandy Mann" wrote in message ... Try using Data Text to Columns... and use a forward slash as the deliminator in step 2 and in the 3rd step select the adjacent cell. HTH Sandy "Parsing data in a cell" <Parsing data in a wrote in message ... I have data in a cell that looks like this ".287/.289". I want to parse out the data in the next two adjcent cells. The number .287 in the next column and .289 in the column after that. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
How can I do a lookup to a specific cell on multiple worksheets? | Excel Worksheet Functions | |||
How do I use a cell as a referance to a file in a lookup statemen. | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |