Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I select only specific parts of one field?
I have an Excel worksheet of 5000 addresses. I want to select a range of
only certain zipcodes. Unfortunately, the zip is part of one big address field. I have tried many things and can't figure out a way to do this. Any help would be greatly appreciated. |
#2
|
|||
|
|||
Tom Ogilvy posted some code that should accomplish what
you need. Read this thread: http://tinyurl.com/4zu2d HTH Jason Atlanta, GA -----Original Message----- I have an Excel worksheet of 5000 addresses. I want to select a range of only certain zipcodes. Unfortunately, the zip is part of one big address field. I have tried many things and can't figure out a way to do this. Any help would be greatly appreciated. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Page Field | Excel Discussion (Misc queries) | |||
Pivot Tables..I give up... | Excel Worksheet Functions | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) |