Splitting Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top