Separate names, addresses

[odonovanc]

[TABLE="width: 530"]
<tbody>[TR]
[TD="class: xl63, width: 530"]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?[/TD]
[/TR]
</tbody>[/TABLE]

 

[Gerald Higgins]

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.