Find missing and duplicate values in a list of serial numbers in Excel and Google sheets.

Joining text from two columns, removing unwanted spaces in a text string and using function googletranslate()