deleting all error characters

[zachg]

I'm sure you're all familiar with that weird little error rectangle. Well, my spreadsheet is peppered with it. I'm not sure why, but since it was merged from data from countless different sources, it could be a number of reasons.

I'm trying to find a quick way to delete instances of it, since it is screws up the mail merge in Word. I would just use find and replace, but I don't know how to generate that character! I can't find it in symbols either. Any ideas on this one?

Thanks as usual,
Zach

[shg]

Try =CLEAN(A1)

[zachg]

Very dumb question, but where do I type that formula?

[shg]

In a vacant column. Then copy the column, and paste values over the original data.

[zachg]

Thanks! That totally solved my problem.

Zach

[shg]

You're welcome