Postal Letter

Extracting postal codes in Microsoft Excel?

please help - anybody!! I have a microsoft excel spreadsheet. There are hundres and hundreds of addresses. (There is one address per cell). How do i extract the postal codes so that I can make one colum of just the postal codes and eliminate everything else in the address? The post code format is L8J 1H7 for example. Please help someone! Thank you. Thanks so much. Im going to try these techniques out. (Yes, the address' are all over the place. Horrible, i know. Thanks so much though.

Public Comments

1. Go to the 'MrExcel' website; this guy is the best & is highly recommended. Give it a Google & link up.
2. without seeing a sample of all your addresses, it's hard to tell. Assuming the postal code is always the last 7 digits of the address (like 123 Main Street, Toronto, Ontario L8J 1H7), then it's fairly easy. in some cell just enter something like =RIGHT(A1, 7) (where A1 is the cell with your address) this will copy 7 characters starting from the right side of A1 if your postal codes are all over the place (ie: not always the last 7 digits) then it's going to be very difficult (if not impossible) to do it. Post several samples of addresses and maybe someone can find a formula that'll work.