Extracting last 5 characters from a cell

C

colleen Curley

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
 
Top