asked on

Advanced finding in Excel

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

Norie

Do you have a list of the characters you are looking for?

D Patel

ASKER

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

SOLUTION

Norie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

D Patel

ASKER

It will be great help if it is possible.

I mean I don't have an idea whether the character which I am going to find is exist or not.

ASKER CERTIFIED SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

D Patel

ASKER

Hi Rob Henson,

Thank you for your help...

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.

Thanks in advance.
D Patel

SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

D Patel

ASKER

Thanks for support

D Patel

ASKER

Thanks Experts for the Help....