How to replace vector value '0' to NaN( 0 -> Nan)

If my vector is like

For example ) If my vector is like "Distance = { 0 1 2 3 0 4 0 5 0 6 7 8 0 9 10 } "...

And What I want is "Distance = { Nan 1 2 3 Nan 4 Nan 5 Nan 6 7 8 Nan 9 10}";

Literally, I want to change value 0 to value Nan.

[Stephen23]

There does not seem to be any benefit here to using a cell array, your code will be simpler and much more efficient if you just use a basic numeric vector:

https://www.mathworks.com/help/matlab/math/creating-and-concatenating-matrices.html

Answer 1

[Alan Stevens]

>> Distance = [0 1 2 3 0 4 0 5 0 6 7 8 0 9 10]

Distance =

     0     1     2     3     0     4     0     5     0     6     7     8     0     9    10

>> Distance(Distance==0)=NaN

Distance =

   NaN     1     2     3   NaN     4   NaN     5   NaN     6     7     8   NaN     9    10

NB Just use square brackets to define a vector, unless you really want to set it up as a series of cells.

[Vladimir Sovkov]

If the cell array is what really wanted, use the function cell2mat to first convert it to the double array, do with it what Alan recommended, then convert it back to the cell array with the function mat2cell. In the Alan code, if you like it, you can also use Distance(~Distance)=NaN instead of Distance(Distance==0)=NaN.

[Jingyu Yang]

How about in time table?