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
 
You must log in or register to reply here.

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

Similar Threads

Splitting contents of column into 4 3
alphabetical order within a cell 5
Split up 4
Split Address Correction 1
Splitting Cell Data 5
Merging and splitting? 3
Word Removing unwanted "lines" within a MS Word 10 table 1
Replace cell values in multiple columns 3

Back
Top