ExcelBanter - Splitting Values

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Splitting Values (https://www.excelbanter.com/new-users-excel/28624-splitting-values.html)

Zip Codes

Splitting Values

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?

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

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

All times are GMT +1. The time now is 02:52 PM.