Neither for me, but this does work.

Sub Remove_Tab()
Selection.Replace What:=Chr(9), Replacement:=Chr(32), _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
End Sub


Gord Dibben MS Excel MVP

On Wed, 28 Feb 2007 10:55:02 -0600, Dave Peterson
wrote:

It would be the same as =char(9) in a cell, but alt-0009 didn't work for me.

BEEJAY wrote:

What character to be used to enter a "tab" in the find box?