Hi,
I perform a data query from Excel that pulls in values. Occassionally, UTF-16 characters will included which get converted into jibberish (e.g., AV976BC＃脱è½é…¸). I would like to keep my file in a non-UTF-16 format, but be able to identify cells that contain these transformed UTF-16 values and use a formula to transform them to UTF-16 or some how clean them up. Any thoughts?

Correct cell value = AV976BC#ABA
Multibyte cell value = AV976BC＃脱è½é…¸

I want the "＃脱è½é…¸" to be transformed into #ABA (or be trimmed off) in this example. The junk is different depending on the cell.

Thanks,
John