Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Square as character (Office 2000)

    I have a document where at the end of some words I get this funny character in the form of a square. How can I find out what exactly that is? I tried to copy/paste it to the Find/Replace box to replace them with a space or something, but it doesn't even get copied over, like it didn't exist.
    I need to delete these characters, but if I don't know what they are, how can I delete them? I have hundreds in this document, so it's impossible to go line by line and remove them one by one. Any suggestions?
    You can see the character attached to the end of a highlighted word, but others are also visible.

    Thanks,
    K
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Square as character (Office 2000)

    The extension is just visible in the screenshot - it's not a Word document, but a text file produced by another application, I suppose. The squares are probably line feeds or carriage returns.

    Try the following:
    <UL><LI>Make a copy to be on the safe side.
    <LI>Open the Replace dialog (Ctrl+H)
    <LI>Type ^13 into the Find Box
    <LI>Type the code for a paragraph mark ^p into the Replace box
    <LI>Click Replace All
    <LI>If nothing is found, type ^10 into the Find box instead of ^13[/list]If that creates too many empty lines, undo it, and try leaving the replace box empty, then Replace All.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Square as character (Office 2000)

    Ok, thanks, I'll give it a try and if it doesn't work, will post back.

    Regards,
    K.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Square as character (Office 2000)

    In the event that these are not line feeds, and the characters only occur after numbers that have the pattern you showed, you could try a Find/Replace like this.

    Using wildcards
    Find: (T[0-9]{8})[!^13^l,./?;:"//$/#]
    Replace: 1

    This will find all 8 digit numbers starting with T & remove the next character that is not a paragraph mark, line feed, comma, period, question mark, semi-colon or colon, quote, forward slash, $, or #. Make a backup copy first, in case you have other patterns that this affects.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Square as character (Office 2000)

    Alternatively:
    Select one of the squares.
    Switch to the Visual Basic Editor (Alt+F11).
    Activate the Immediate window (Ctrl+G).
    Type ? Asc(Selection) and press Enter.
    This will display a number; memorize this.
    Switch back to Word.
    Activate the Replace dialog (Ctrl+H).
    Type ^ followed by the number you memorized in the Find What box.
    Replace by either ^p or by nothing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •