Delete rows with NaN for a cell array

I want to remove the rows that have NaN and still keep the dimension of the array intact.

 [              NaN]    [        NaN]    [       NaN]    [           NaN]
    [              NaN]    [        NaN]    [       NaN]    [           NaN]
    'Total RADIO Drops'    'Total Drops'    'CC DCR (%)'    'RADIO  DCR (%)'

Above is just an example, I have over a thousand rows.

The only problem I have now is removing rows which have NaN and string together

Thank you

[Rooy]

Is there a way to delete the rows which have strings and Nan mixed together ?

    [              'A']    [        NaN]    [       NaN]    [           NaN]
    'Total RADIO Drops'    'Total Drops'    'CC DCR (%)'    'RADIO  DCR (%)'

Answer 1

[Tom]

A(any(cellfun(@(x) any(isnan(x)),A),2),:) = [];

[Rooy]

Thank you, it works

Answer 2

[Andrei Bobrov]

A - your cell array

out = A(any(cellfun(@(x)any(~isnan(x)),A),2),:);

ADD

out = A(all(cellfun(@(x)any(~isnan(x)),A),2),:);

[Rooy]

That works thank you, is there a way to delete the rows which have strings and Nan mixed together ?

[Andrei Bobrov]

see ADD part in my answer

[Rooy]

Thank you for your great help

[YING CONG XIAO]

hi Andrei,

how to specify the range in this fun:

out = A(any(cellfun(@(x)any(~isnan(x)),A),2),:);