-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
postal code
-
L
Excel Formula or Macros - Distance Between Two Postal Codes
Hi, I'm from Canada & I'm trying to see if there is a formula or macros I can use to calculate the distance (KM) between two postal codes. A1 - Postal Code 1 B1 - Postal Code 1 C1 - Distance (KM) Any help would be greatly appreciated. Thanks, Laurinda- LaurindaS
- Thread
- canada distance formula postal postal code
- Replies: 5
- Forum: Excel Questions
-
P
Look up Canadian Postal Codes Using Street Address
I have an Excel database that contains over 3000 Canadian street addresses, but I am missing the postal codes for these addresses. Is there anyway to automatically look up the postal codes for all of these addresses? Please HELP!!! Thanks- Postmaster
- Thread
- address lookup canada mailing address postal code
- Replies: 3
- Forum: Excel Questions
-
S
Excel formula to distinguish multiple alphanumeric formats needed!
Hello! I have a list of manually entered postcodes in excel which I am trying to work with. What I am trying to achieve is a formula that recognises when these postcodes are entered with an incorrect alphanumeric format. So all post codes I am working with should begin with an alphanumeric...- sst0189
- Thread
- alpha numeric excel formula postal code
- Replies: 8
- Forum: Excel Questions
-
C
Custom Format With Space
User enters text into a cell such as: T2K5G1. I want the custom format to convert that to: T2K 5G1. So it's the same thing with just a space in between. I tried 000 000 in the custom format but that didn't work. Suggestions?- cool1_boy1
- Thread
- custom format excel 2013 format cells postal code
- Replies: 3
- Forum: Excel Questions
