move a special character
 

Hi Mark,

Those little squares normally represent an unprintable character such as a
carriage return. But in your attached file are a vertical tab chr(11), and
according to help not used in Excel.

You could use the Clean fuction as suggested by Mike Q, but that might also
remove other unprintable characters you want to keep.

Try this having saved a backup -

Sub RemVtabs()

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

Regards,
Peter T





"Mark" wrote in message
...
Hi,
Anyone knows how to move a small
rectangle character out from excel cell.
Please see attached file, real file contains
more than 8000 records.
Thanks,

--
Mark