Extracting last 5 characters from a cell

[Guest]

I am trying to extract the last 5 characters from a cell and enter them in a
seperate cell. I have several thousand addresses that I have in excel and I
want to pull the zip codes out and have them in a seperate cell so I can sort
them by zip code.
Basically cell A is a complete address and I want cell B to contain the zip
codes

 

[Ron de Bruin]

Hi colleen

See the Excel help for the right function

=RIGHT(A1,5)

 

[Guest]

You are a life saver. Thanks

Colleen

Hi colleen

See the Excel help for the right function

=RIGHT(A1,5)