Or simply use Alt + 0160 in the replace what dialog.


Gord Dibben MS Excel MVP

On Sat, 29 May 2010 19:49:14 -0300, "Bernard Liengme"
wrote:

In some empty cell type formula =char(160)
This is a non-breaking spaces - it will be invisible
Select and copy that character
Use this in the Find & Replace dialog
best wishes