Assuming the data you are interested in is always in column B:
[~,~,raw]=xlsread(fullFileName,'Results','B:B');
raw(any(cellfun(@(x) any(isnan(x)),raw),2),:) = [];
This code will leave you with a cell array with the raw data for all non-empty cells in column B. As written it will read all of the rows (65,536 of them!) in each file. If you know the maximum number of non-empty rows in all files (say 1500), you could speed this up by replacing 'B:B' with 'B1:B1500'.
This thread contains more information about deleting rows with NaN entires.
Best Answer