why does xlsread deletes NaN for cells with text?

when applying xlsread for an excel sheet with both numbers and text, xlsread deletes the cells that contains text instead of writing NaN. How can i avoid this? I want it to write NaN so i can use isnan()=0

Answer 1

[Andrei Bobrov]

use

[~,~,c] = xlsread(...)

eg

[~,~,c] = xlsread('yourfile.xlsx')
out = zeros(size(c))
lc = cellfun(@(x)ischar(x),c);
out(lc) = nan;
out(~lc) = [c{~lc}];