mailing address

  1. 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
  2. S

    How do I reformat my address book

    My boss handed me a notepad text filled with address when I placed it on excel it looked like they all went on column A like so: <tbody> A B C Company's Name Name Address Company's Name Name Address </tbody> I want to fix it so that the Name and Address would go to...
  3. S

    How to find Partial Duplicates of Mailing Addresses

    I have one column of Addresses with partial duplicates that need to be highlighted. However, I can't do a simple COUNTIF or MATCH to find the duplicates because these are all slightly different. Here is an example: FIRST LAST ADDRESS STATE Jane...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top