Forum Discussion
Solved
How to remove data that is in unicode format
Extracted data from Open Street Maps and many of names are actually unicode. The names are not critical for our use so we want to just filter out records/cells with unicode symbols and leave behind...
PeterBartholomew1 Thank you. Will try that out tomorrow.
It would be somewhat slow and tedious but you could use MID to extract an array of single characters from text and then test the array using the formula
= AND( UNICODE( chr ) <= 255 )
TRUE would be retain and FALSE delete.
PeterBartholomew1 Thank you. Will try that out tomorrow.