Only keep specified characters
Hi there,
I have a spreadsheet with addresses in different alphabets, but I only want to keep characters from the Latin alphabet as well as some symbols. For example:
河南省 Henan Province becomes just Henan Province
221/B, [Baker Street] becomes just 221/B, Baker Street
I know there’s a way to filter out rows containing undesired characters, and another way to specify which characters to remove, but I think it’d be easier in my case to specify which characters to keep. Is this possible?
Many thanks!