I'm sorry but I don't understand what you are looking for. Code 2 is the code that I gave you http://www.mathworks.fr/matlabcentral/answers/42710-problem-with-xlsread-bizarre-results
R is the raw output of the xlsread function. In each cell, there is a numeric or a string. So R(1,3) is a cell, and you are checking one value to erase the column of your cell array. In code 2 you are using a command (cellfun)used to manage cell arrays just for one cell, and after, you don't use TT !!
*for erasing the first row of R if cell R(1,3) is occupied by NaN *
if all(isnan( R{1,3} ))
R(1,:) = []
end
