how to delete NaN from a column of data

I have a column of numbers that i called in from excel but some of my data comes up as NaN, which is fine but i need to do calculations on this data and matlab cant do calculations on NaN how can i get rid of the NaN from my data?

example

data=

45

23

NaN

78

mean(data) = NaN

Answer 1

[Geoff]

If all you want is the mean, just use nanmean:

help nanmean

There are a bunch of functions that explicitly ignore NaN

 nancov
 nanmax
 nanmean
 nanmedian
 nanmin
 nanstd
 nansum
 nanvar

[Shubham Maurya]

try this

    data(find(isnan(data)))=[];

[Image Analyst]

Like James showed, find() is not needed, though it still works.

data(isnan(data)) = [];

Answer 2

[James Tursa]

For your particular example:

mean(data(~isnan(data)))

For general nan handling, you might take a look at the FEX submissions such as this one:

http://www.mathworks.com/matlabcentral/fileexchange/6837-nan-suite