I have a long column with town state and zip code appearing like this

Farmington, CT 06032

can a macro be made, or is there a command that will take the last five
characters from each of these cells and put them somewhere else?