How to remove #N/A?

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

Jan
Jan on 19 May 2021
Where do you see this output? What are the values in Matlab?
I imported this from Excel
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)

Asked:

on 19 May 2021

Commented:

on 19 May 2021

Community Treasure Hunt

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

Start Hunting!