How to remove a word from a column of cells
Posted on 2011-09-18
Hi all, I'm a bit new to the website, I had a quick look around existing answers and couldn't come across anything like this:
Basically, I'm trying to clean up addresses. In the addresses column, words such as "Suite", "level", "unit" etc recur. Those words do not necessarily start from the front of the cell and due to data entry errors, are not always separated by a space.
Is there a formula / function or a macro which can identify the words in the cells and automatically delete it from the cells?
Otherwise, happy with a response which can help me automatically delete the word but not detect instances where the word is not separated by a space.