MATLAB Answers

Replace NaN value to blank in excel

46 views (last 30 days)
joo  tan
joo tan on 19 Oct 2012
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?

Answers (2)

Sachin Ganjare
Sachin Ganjare on 19 Oct 2012
I think this what you need:
Hope it helps!!
  2 Comments

Sign in to comment.


Azzi Abdelmalek
Azzi Abdelmalek on 19 Oct 2012
num=xlsread('YourFileName.xls');
num(:,3)=[]

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!