yah,

just now tested with different conditions, I think ur formula works
fine

On Sep 14, 7:30*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
That works in that particular case, but that C1 formula doesn't cope with
varying lengths of the string instead of 101.9.
I think it needs to be a bit more complicated, see my reply earlier.
--
David Biddulph

"muddan madhu" wrote in message

...
Try this

B1 put this formula =MID(LEFT(A1,FIND("|",A1)-1),FIND(" ",A1),255)

in C1 put this formula = =MID(A1,FIND(":",A1)+1,FIND(":",A1)-
FIND("|",A1))

On Sep 14, 6:33 pm, Eric wrote:

Does anyone have any suggestions on how to retrieve values within cells?
In cell A1, there is a text as shown below
Indices September 14, 2008 | ABCD: 101.9 | POIUYT: 70.06 |
I would like to retrieve the date September 14, 2008 into cell B1, and
the value 101.9 in cell C1.
Does anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
Eric