0

I have a long list of addresses which contains letters, numbers, special characters and some local language characters. Is there a way that able to identify those cell that contain local language character?

Sample:

65/1 Muban สำโรง Moo 6

phuclv
  • 26,555
  • 15
  • 113
  • 235
SWei
  • 3
  • 2
  • google docs has a [`DETECTLANGUAGE` function](https://support.google.com/docs/answer/3093278?hl=en). Unfortunately there's nothing like that in Excel – phuclv Apr 14 '22 at 15:56

1 Answers1

0
  1. Separate string so that there is only 1 character in each cell (e.g. if A1 is "cat" it should be separated out to B1:c C1:a D1:t)
  2. Get the unicode value for each character (e.g. =unicode(B1), etc.)
  3. Create a lookup function that links to another table (that you will need to create) that indicates which unicode characters link to which local languages. Determine which ones you find acceptable for your purpose.
Brian
  • 977
  • 1
  • 9
  • 24