Special characters

Rick · May 13, 2004

In Office 2003/Excel, how can I Find and Replace Special
Characters, like a Hard Return left by another
version/product?

Gord Dibben · May 14, 2004

Rick

Hard reurns are usually 0010.

Try Edit>Replace

What: ALT + 0100
With: nothing or a space(your choice)

Gord Dibben Excel MVP