Replace NaN value to blank in excel

I have excel file with 3 column. The third column has NaN value. i need to replace the NaN value to blank...I not familiar with using excel in matlab .Can help me?

Answer 1

[Sachin Ganjare]

I think this what you need:

http://www.mathworks.com/matlabcentral/fileexchange/10847

Hope it helps!!

[Sachin Ganjare]

This script will perform required operations.

For Example:

Data = readfromexcel(File,'All');

Data = cellNaNReplace (Data,0);

[Sachin Ganjare]

Also you can refer:

http://www.mathworks.com/matlabcentral/answers/43368-replace-nan-s-with-blanks

Hope it helps!!!

Answer 2

[Azzi Abdelmalek]

num=xlsread('YourFileName.xls');
num(:,3)=[]