Find symbol (Excel 2003)

Topic

New Reply

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.

Reply | Quote

Replies

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?

Reply | Quote

Thanks Hans,

It works.

Reply | Quote