In excel, finding the addresses in a circle can be useful to design any direct mail campaign. How to find zip codes inside a radius in an excel sheet?
1) Open an excel sheet.
2) Right-click on any cell and select InsertCDXFindRadius Function.
3) A pop-up window will appear. Fill in the zip code ad radius, and then click OK.
4) A list will appear showing all the zip codes along with the radius.
USING SEARCH BUG
1) Go to www.searchbug.com
2) Go to tools->zip code->by radius.
3) Enter the zip code and the radius you want to find in.
4) Click on OK.
5) A list will pop as shown, giving all the names of city and country with that zip code and within that radius.
