move a special character

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

=clean(A1)
Drag formula down as far as nessary
Then Copy & PasteValue to a new spreadsheet
--
Mike Q.


"Mark" wrote:

> 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
>
>
>

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" <[email protected]> wrote in message
news:#[email protected]...
> 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
>
>
>

Thanks,
Mark




"Mark" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
>
>