Splitting Values

Z

Zip Codes

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?
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top