Importing a certain value on the cell (Excel)

My problem is quite specific. I would like to import a certain value on the excel cells. The problem is that cell includes both text and numbers. For example "G(function1): Expected Value=0.5" I just like to import 0.5 value from this cell to matlab. How can I do that?

[Stephen23]

"How can I do that?"

Import the text, then extract the value. What have you tried so far?

Answer 1

[Jan]

Something like this might work:

[num, txt] = xlsread(FileName, 'C5:C5');
[dum, str] = strtok(txt{1}, '=');
str(1)     = [];

[ugur uresin]

That's it! It works...