Hi everyone new guy here, I just want to ask if there's a way I can highlight all the foreign characters like Japanese, Chinese character etc... ?
Thank you in advance..
Hi everyone new guy here, I just want to ask if there's a way I can highlight all the foreign characters like Japanese, Chinese character etc... ?
Thank you in advance..
Hi RAguilar,
Do you a have list of all potential characters that you want to highlight?
You could then use a Find Function & Conditionally format them.
Or a Macro could do the above.
Just a thought.
Remember you are unique, like everyone else
Pretty much CHAR(65) to CHAR(128) covers a-z and A-Z, so maybe you could use something like =AND(CODE(cell-ref)>=65,CODE(cell-ref)<=128)...this would give the english alphabet
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Based on a UDF i picked up on here (can't find the thread anymore):
![]()
Function MultibyteChecker(txt As String) As Boolean Dim aB() As Byte Dim n As Long aB = txt For n = LBound(aB) + 1 To UBound(aB) Step 2 If aB(n) <> 0 Then MultibyteChecker = True Exit Function End If Next n End Function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks