List Formula

M

mkd

I have a problem with excel.
For example, I have a generic list like this:

3,40
2,05
#N/D
#N/D
#N/D
-1,5
#N/D
2,30

I would like (NOT VBA!) that excel give me a list without #N/D, in the
following form

3,40
2,05
-1,5
2,30

without spaces...
Which formula can I use?

Thanks.
 
Top