Regular expressions and data validation
Similar Posts
Google sheetsJoining text, removing unwanted spaces and using function googletranslate 
Joining text from two columns, removing unwanted spaces in a text string and using function googletranslate()
