Sub Remove_NON_BRK_SPC()
Selection.Replace What:=Chr(160), Replacement:="", _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
End Sub


Gord

On Mon, 19 Mar 2007 15:58:08 -0700, BRGIII48
wrote:

Gord,

Tried the paste special and Excel still doesn't recognize. What is the
marco option?

Thanks for your help!