Get non UTF-8 compliant character from cell

[futesch]

Hi all,

We would highly appreciate, if you could help us with the following challenge:

We would like to 1.) split my data into UTF-8 conform and non-conform groups, and 2.) get for the non-UTF-8 conform cells the sign that causes the cell to be not compliant with the UTF-8 format.

Please find our current approach attached. Sadly, we were not able to get the second challenge to be working.

Many thanks in advance for your support!

Fredrik

[Christina_H · Accepted solution]

Try this, using the DecomposeUnicodeForMatch function to identify non-compliant characters