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()
Joining text from two columns, removing unwanted spaces in a text string and using function googletranslate()
https://youtu.be/oZCt618goCQ