I am trying to split a cell but only take the last 2 characters out. I have used a formula but it doesn't delete the 2 characters from the original cell, it only copies them to the next cell. Can someone tell me how I can do this.
i.e. I need to move "ON" from St. Catharines ON.