# zip codes

1. ### Upper limit of geography data type conversion?

Hi, I am trying to find the distance between zip codes in separate columns in a work book. To do that I need to convert a full column of text zip codes into the geography data type. The problem is that my dataset is large, 300k+ rows, and Excel cannot handle converting the entire column at...
2. ### Excel Calculate Miles from Zip Code to Zip Code

I am aware that there are other similar questions like this on here, but they seem to be pieced together, and I cannot seem to find a single answer that can be easily deployed. I previously used G_Distance function to calculate miles between a matrix of zip codes, and it worked flawlessly. I now...
3. ### Vlookup between 2 zip codes

I need help here. I have tried to find an answer but nothing. My problem is that I got lot of Zip Codes that connect to a spesific sales Rep. A4 3000 B4 3069 C4 Person 1 A5 3070 B5 3299 C5 Person 2 A6 3300 B6 3599 C6 Person 3 F4 is the place I put the Zip code I want to find a match for...
4. ### Urgent - Function needed to done this

Hi, I have problem Please look at the picture below: In this picture you can each url ending with pagenum=1 There are 29670 rows in excel sheet and all ending with pagenum=1 And also you can see the zip code which is "Ab10" for all 29670 rows. WHAT I AM LOOKING FOR A FUNCTION THAT WILL...
5. ### Handling duplicate zips: Combining non-numeric columns into one column, one row.

Is there a function in Excel that allows you to combine non-numeric columns as a list? For example, 91401 is a zip shared by three cities: Van Nuys, Sherman Oaks and Valley Glen. The data is in a workbook as three rows (each with 91401 as the first column, and cities listed individually...
6. ### Trouble with XL2007 Advanced Filter on Many Zip Codes

Hello, I have followed a tutorial located at: http://www.contextures.com/xladvfilter02.html#TopFive I have Excel 2007 and Win7 What I'm attempting to do is is take sheet1 with 100's of rows of data and about 20 different columns where most rows contain a zip code. I would like to use an...
7. ### VLOOKUP problem with zip codes

VLOOKUP returns incorrect results when comparing zip codes across worksheets. I think the problem could be caused by 2 things: 1. There are duplicate rows in the lookup_value range because each represents an individual and needs to remain a duplicate to show whether there are multiple...
8. ### Parsing names and Zip code questions

I do a lot of spreadsheets where the original may have a set up like this Column A: James Doe Jr Jonathan Doe Jr I need it set up with the first name in the first column and the last name and Jr put into the second column. I have tried text to columns but it puts each part of the name as...

### 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.

### Which adblocker are you using?

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

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