caroutisine
New Member
- Joined
- Jun 23, 2003
- Messages
- 11
I have an export from an access database that puts the customer number, name, and address into an excel spreadsheet. The problem is that it puts the city, state and zip code into one cell for each customer. I need to sort by state and zip code, so I need to separate the city, state and zip code into three separate cells for each customer. There is no comma between the city and the state, only spaces.
There are a couple of issues that I'm having trouble with to sort this data:
1. The city may have one or more space between the name:
Example:
Fergus Falls MN 56537
or
South San Francisco CA 90025
2. Some of the Zip codes include the zip + 4
Example:
Louisville KY 40232-5070
Is there a way to tell Excel to take the 5 (or 5+4) numbers at the end of the cell entry and insert it into the next column? Then do the same thing with the state abbreviations? The state abbreviations are the only consistent thing in the cells, they are always between the city and the zip code, and are always two letters...can this somehow be used to tell Excel what to do?
Any help would be greatly appreciated.
There are a couple of issues that I'm having trouble with to sort this data:
1. The city may have one or more space between the name:
Example:
Fergus Falls MN 56537
or
South San Francisco CA 90025
2. Some of the Zip codes include the zip + 4
Example:
Louisville KY 40232-5070
Is there a way to tell Excel to take the 5 (or 5+4) numbers at the end of the cell entry and insert it into the next column? Then do the same thing with the state abbreviations? The state abbreviations are the only consistent thing in the cells, they are always between the city and the zip code, and are always two letters...can this somehow be used to tell Excel what to do?
Any help would be greatly appreciated.
