I have a downloaded zip code list that shows the 5 digit numeric zip code and the city which it is in. I'm building a database for a website and need to extract the zip code and city seperately to populate zipCode and city fields in the database. been looking for something already done for me for the state of Texas with no luck. Is there a formula that I can use to seperate the numeric and alpha parts of the record. Once I have this I can export to my database program. I appreciate any help with this matter.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
extracting numerics and alphas from cells
- Thread starter DevDevil
- Start date
barry houdini
MrExcel MVP
- Joined
- Mar 23, 2005
- Messages
- 20,825
Welcome to the board
What does your data look like, do you just have zip code and City in one cell with no other data - what separates the two?
If it's something like
12345 Dallas
then can you not use Data > Text to columns to split into separate columns?
What does your data look like, do you just have zip code and City in one cell with no other data - what separates the two?
If it's something like
12345 Dallas
then can you not use Data > Text to columns to split into separate columns?
Upvote
0
Is it all run together as in "99999SanLuis" or is it delimited with a space such as "99999 SanLuis"?
If the first case, you can use the Left(), Mid() and Right() functions for parsing.
If the second case, you can use text-to-columns found under the data menu.
If the first case, you can use the Left(), Mid() and Right() functions for parsing.
If the second case, you can use text-to-columns found under the data menu.
Upvote
0
