Value to =na()

[hannes]

How can I convert all cells containing # to the formula =na()

thanks

[olasa]

One way:
=IF(ISERROR(FIND("#",A1)),NA(),"")

Ola Sandström

[hannes]

how would i apply this using a macro since the function you have given seems to be an excel function and considering that it needs to be applied to over 60.000 cells it seems not feasible in this manner.

thanks