Clear Filters
Clear Filters

Extracting a specific number from an excel cell

4 views (last 30 days)
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!

Accepted Answer

Akira Agata
Akira Agata on 6 Jun 2019
How about the following?
[~,~,C] = xlsread('yourExcel.xlsx');
C = extractBetween(C,'(',')');
C = extractAfter(C,' ');
data = str2double(C);

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!