Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding UTF-8 characters in Excel or Access

Status
Not open for further replies.

SpeedStick

Technical User
May 24, 2007
37
0
0
US
I need to identify characters/words that are UTF-8. I am just trying to either highlight a cell, a word or a letter that indicates it is UTF-8. I currently have the data stored in Microsoft Access and I will export it Microsoft Excel.

The ultimate goal would be to try to separate UTF-8 words from not UTF-8 words.

UTF-8 examples:
Höhenstraße 27
Drève Richelle, 161 BatG
Rue du Trône 108

Non-UTF-8 Examples:
Chemin du Foriest
300 avenue Provinciale

Any assistance would be great.
 
Non-UTF-8 Examples:
Chemin du Foriest
300 avenue Provinciale

Well ... no. The first 128 characters of UTF-8 are exactly the same as the ASCII character set (and hence the first 128 characters of of the Western code pages used by Windows). They are completely indistinguishable.

UTF-8 examples:
Höhenstraße 27
Drève Richelle, 161 BatG
Rue du Trône 108

Just looks like code page 1252 to me ...

Why do you think it is UTF-8?


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top