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?
回答（2 个）
Sachin Ganjare
2012-10-19
0 个投票
2 个评论
Sachin Ganjare
2012-10-19
This script will perform required operations.
For Example:
Data = readfromexcel(File,'All');
Data = cellNaNReplace (Data,0);
Sachin Ganjare
2012-10-19
Also you can refer:
Hope it helps!!!
Azzi Abdelmalek
2012-10-19
num=xlsread('YourFileName.xls');
num(:,3)=[]
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
