MATLAB: Extracting a specific number from an excel cell

celldataexcelextrapolate

Hi all!
I'm new on MATLAB and I have to extrapolate a specific data from a cell in an excel sheet, to assign it a name and put it in a new array. The problem is that I don't need all the values in the cell, but only the last one, as in the picture.
Cattura.PNG
How can I do it?
Thank you!

Best Answer

  • How about the following?
    [~,~,C] = xlsread('yourExcel.xlsx');
    C = extractBetween(C,'(',')');
    C = extractAfter(C,' ');
    data = str2double(C);