Cell 'Find And Replace'

Finds all occurrences of NaN in a cell array and replaces them.

cellData=cellNaNReplace (cellData, replaceWith)

Accepts a cell array and a char/integer and replaces all occurrences of NaN in that cell array with the 'replaceWith' value. This is especially useful when using 'readfromexcel' or other excel importers since they sometimes put NaN instead of empty cells.

Example of usage:
a = num2cell([0 1 2 NaN 4]);
b = cellNaNReplace (a,'');

or, if you're dealing with excel spreadsheets, you can use:

Data = readfromexcel(File,'All');
Data = cellNaNReplace (Data,0);

Enjoy.