Obtain empty cells if I import empty cells from excel

Dear all, I am importing a matrix of data (either strings or numbers) as follow:

data_mine=importdata('namefile.xlsx');

In the file there are some empty cells and Matlab imports those as NaN, how could I obtain empty cells? or how could I convert the NaN cells in empty ones?

Thanks a lot

Pinna

Answer 1

[Image Analyst]

Look at the raw output of xlsread() - that's the third return argument. It's an .xlsx file so you should use xlsread() instead of importdata() anyway, I believe.