| Joe & Sue Smith 123 Main St Chicago, IL 60601 Lets say I have a large column of data in this exact format. Any way I can separate this out quickly in excel into a name, then address, then city, state, zip formats? |
<tbody>
</tbody>
-
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.
Separate names, addresses
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
Hi - questions like this come up very very frequently on this board - have you tried searching ?
You say you have "...data in this exact format" but what usually happens is that name and address data does NOT always comply with standard formats.
Which makes it difficult to parse out.
For example some minor variations which could make it very difficult to write rules to break up the data . . .
Joe & Sue Smith 123 Parkway South Chicago, IL 60601
Joe & Sue Smith 123 Parkway St Louis, IL 60601
and so on.
You say you have "...data in this exact format" but what usually happens is that name and address data does NOT always comply with standard formats.
Which makes it difficult to parse out.
For example some minor variations which could make it very difficult to write rules to break up the data . . .
Joe & Sue Smith 123 Parkway South Chicago, IL 60601
Joe & Sue Smith 123 Parkway St Louis, IL 60601
and so on.
Upvote
0
Similar threads
- Question
- Solved
- Solved
