MATLAB Answers

Removing NaN from matrix

2 views (last 30 days)
John Good
John Good on 27 Nov 2020
I am trying to import an excel but the blank cells are coming through as NaN if I class them as a number which I need to do. I have attached a photo. I need the empty cells to be recognised as nothing, not 0 or NaN.

  0 Comments

Sign in to comment.

Answers (1)

Sulaymon Eshkabilov
Sulaymon Eshkabilov on 27 Nov 2020
Use isnan() and assign the value you want or remove the points containing NaNs. See help how to employ it: mathworks.com/help/matlab/ref/isnan.html?searchHighlight=isnan&s_tid=srchtitle

  0 Comments

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!