Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2005
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find symbol (Excel 2003)

    Dear All,

    I have been trying to find special characters such as (smaller or equal to), (bigger or equal to) or (sigma) by pasting that character into the field of Find dialog box, but for some reasons none can be found. I am sure the special character is there. Did I do something wrong?

    Thank you in advance.

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

    Re: Find symbol (Excel 2003)

    As you can see, the Lounge doesn't handle Unicode characters well.

    Excel can search for Unicode characters.
    - Click Options >> in the Edit | Find dialog.
    - Make sure that the check boxes "Match case" and "Match entire cell contents" are cleared.
    - Make sure that Values is selected in the "Look in" dropdown.
    Does that help?

  3. #3
    Star Lounger
    Join Date
    Feb 2005
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find symbol (Excel 2003)

    Thanks Hans,

    It works.

Posting Permissions

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