How to remove #N/A?

10 views (last 30 days)
Chiara Scarpellini
Chiara Scarpellini on 19 May 2021
Commented: per isakson on 19 May 2021
I would like to replace all of the elements #N/A of the vector with zeros
#N/A
1336.94
#N/A
#N/A
#N/A
#N/A
1271.44
1336.94
1967.27
3190.22
3207.76
  3 Comments
Chiara Scarpellini
Chiara Scarpellini on 19 May 2021
I imported this from Excel
per isakson
per isakson on 19 May 2021
In Excel #N/A stands for "null (#N/A) values".
When (R2018b) I import numerical data that contains #N/A it is converted to NaN in Matlab. How did you import from Excel ?

Sign in to comment.

Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!