How to keep only numbers in a cell (.xlsx file)?

I have an .xlsx file. In one column there are numbers and text in each cell (e.g. 0.562550 (AHV)).

How could I keep ONLY the number of each cell (e.g. ONLY the 0.562550) ??

I am uploading the file in order to understand.

Thank you in advance

Answer 1

[Walter Roberson]

c = readcell('test.xlsx');
data = cellfun(@(C) str2double(regexprep(C, '\(.*', '')), c)

Answer 2

[Ive J]

x = readcell('test.xlsx')
nums = cellfun(@(x)sscanf(x, '%f', 1), x)
    1.4420
    0.3320
    0.3560
    0.8530
  250.8690
    8.8190

[Walter Roberson]

Good point. Though I might suggest adding a size to the sscanf() to prevent it from trying to look for more values, and as a guard against the possibility of having a second value that looked like a number in the cell.

[Ive J]

True, this works only for simple situations like this. Otherwise, regexp would guard against those sloppiness with sscanf and more complex formats. Now I've modified it, tanx!