MATLAB: Detecting NaN in cell array

Question

I have a 54×8 cell array that contains only strings. Most of these strings represent numbers and I would like to detect which cells are NaN.

One possibility would simply be to replace all NaN with ' ' or to check whether each d{i,j} == NaN.

Thanks

Answer 1

cellfun(@(C) any(isnan(C(:)), YourCell)

However in your situation you could probably go with

cellfun(@isnumeric, C)

Oh wait, when you say NaN, do you mean the string 'NaN' ? If so then

cellfun(@(C) strcmp(C, 'NaN'), C)