Hi there,
I have a *huge* list of company names and want to delete specific suffixes like 'AG', 'SA', 'Corp' etc. Naturally Ctrl + F will not suffice, nor trimming the end of cells.
I am looking for an Excel formula that will be able to target these words specifically (they are the last words in every cell) and delete them. Any pointers on this would be massively appreciated as it's been driving me nuts.
Thank you!!
Bookmarks