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 those that are ok? Maybe some code to search for records with any symbols and delete? (some have letters in them) See column A,
PeterBartholomew1 Thank you. Will try that out tomorrow.
2 Replies
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.
