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