Don't have Telegram yet? Try it now!
https://eduk8.me/2019/05/you-will-soon-be-able-to-remove-duplicates-and-trim-white-space-in-google-sheets/
You will soon be able to remove duplicates and trim white space in Google Sheets