excelnovice
New member
- Joined
- Apr 23, 2013
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hi all, i hope someone can help. I have a file with just one column, but has 3 component data. The first is "city", the second is the "zipcode" and third is "time". for e.g. Bay Minette 36507 10:00am or Bessemer 35020-35021 8:00am
The issue with the data structure is some cases you can have the city name with two parts to its name separated by a space for e.g. Bay Minette and/or you can have the zip code with a range 35020-35021. I want to preserve the integrity of the name and also keep the range togther and split this data into three columns.
How would i go about doing this?
The issue with the data structure is some cases you can have the city name with two parts to its name separated by a space for e.g. Bay Minette and/or you can have the zip code with a range 35020-35021. I want to preserve the integrity of the name and also keep the range togther and split this data into three columns.
How would i go about doing this?