<div>
Do you have a list of the characters you are looking for?
</div>


<div>
No, It could be anything other than a-z, A-Z, 0-9, ~!@#$%^&amp;*()_-+=`;&quot;:' etc...
</div>


<div>
It will be great help if it is possible.<br />
<br />
I mean I don't have an idea whether the character which I am going to find is exist or not.
</div>


ASCII-Codes.xlsx

<div>
Hi Rob Henson,<br />
<br />
Thank you for your help...<br />
<br />
Assume my sheet has 20000+ rows and If I want to find the characters with Ascii Code between 162 to 191, then how do I enter search string in find dialog.<br />
<br />
Thanks in advance.<br />
D Patel
</div>


<div>
Thanks Experts for the Help....
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
Can anybody help me in finding some special symbols, other language characters etc... by using the Excel find option.<br />
<br />
<b>Sample :<br />
</b><br />
Atlastek Boru.Şti.<br />
Hasl Speciál<br />
Hasl - Nerez Speciál<br />
Stål A/S<br />
Mos.Şti<br />
Nart Çelik td. Şti.<br />
Česká Rep<br />
Česká Rep<br />
Česká Rep<br />
Česká Rep<br />
VarzTic. Ld Şti.<br />
<br />
From the above I want to find characters such as <b><i>&quot;Ş&quot;, &quot;Č&quot;, &quot;á&quot; etc...</i></b><br />
<br />
I've more than 10000 rows and out of them I want to identify such symbols.<br />
<br />
How do I? Any help will be highly appreciated..<br />
<br />
Thanks in advance,<br />
D Patel
</div>
</div>


Hello Experts,

Can anybody help me in finding some special symbols, other language characters etc... by using the Excel find option.

Sample :

Atlastek Boru.Şti.
Hasl Speciál
Hasl - Nerez Speciál
Stål A/S
Mos.Şti
Nart Çelik td. Şti.
Česká Rep
Česká Rep
Česká Rep
Česká Rep
VarzTic. Ld Şti.

From the above I want to find characters such as "Ş", "Č", "á" etc...

I've more than 10000 rows and out of them I want to identify such symbols.

How do I? Any help will be highly appreciated..

Thanks in advance,
D Patel

Advanced finding in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.