If you have Farmington, CT 06032 in cell A1
Put this formula in B1 to get the rightmost 5 characters

=RIGHT(A1,5)

Vaya con Dios,
Chuck, CABGx3



"Zip Codes" wrote:

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?