I have characters that look like little boxes in my text in Word. The text is
being brought in from a mainframe download. I want to get rid of these
characters but I can't seem to figure out how.
Work out what character(s) they represent. Select one, then switch to VBA
and in the immediate window use: ? Asc(Selection). That tells you the code
of the first character in the selection. Then use Find and Replace to delete
that character: Search for ^nnn (where nnn is the character number); replace
with nothing.
>I have characters that look like little boxes in my text in Word. The text
>is
> being brought in from a mainframe download. I want to get rid of these
> characters but I can't seem to figure out how.
metflunky - 23 Aug 2005 13:59 GMT
That's awesome, it worked perfectly. Thank you very much.
> Work out what character(s) they represent. Select one, then switch to VBA
> and in the immediate window use: ? Asc(Selection). That tells you the code
[quoted text clipped - 6 lines]
> > being brought in from a mainframe download. I want to get rid of these
> > characters but I can't seem to figure out how.