Trying to come up with an "if" formula for concatenate or something similar

[tuckerpmission]

I have a Zip Code list that has a new record for each zip code. So for example, if a city has 3 zip codes, it will list in 3 entries. I want to combine all in one entry.

For example:

County-City-Zip Code
Orange-Buena Park-90620
Orange-Buena Park-90621
Orange-Buena Park-90622
Orange-Buena Park-90623


So i would like to program a separate entry that will list all 4 zip codes (in the above example). The thing is that there are numerous cities for each county, and i don't want to manually concatenate each one. I would rather have an if formula that will automatically concatenate the same city's zip code together since there is so much data on this spreadsheet.

I am pretty good with excel formulas but this one is stumping me right now... it's Monday.

[Pete_UK]

Does the data appear like that, i.e. separated by hyphens in the same cell, or do your hyphens represent different cells, so the data appears in three different columns?

It would help if you attached a sample Excel workbook. To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

[tuckerpmission]

The hyphens represent new cells. I did this on purpose just in case the alignment/format didn't line them up appropriately under the headers. Attached here. Please reference the OC tab for starters. Thanks for the help!

[Pete_UK]

Did you forget to attach it?

Pete

[tuckerpmission]

I attached the excel worksheet but i can't see where you would open it from?

[tuckerpmission]

I attached the excel worksheet but i can't see where you would open it from?

[tuckerpmission]

should be here...