Remove non-space spaces?
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
|