Parsing an Address Without a Comma

[dash11]

Please help
I'm trying to parse out addresses that do NOT contain a Comma or any other type of delimiter in the address.

I've attached an example workbook. Column A contains the full address that I need parsed out.

[humdingaling]

in your example, you can use space as a delimiter

ie
from the right..1 space = post code
2 space = state
3 space = city
anything before this is street address

however is it always so nicely panned out like this in the real world example?

[humdingaling]

here's a hack and slash method of what i meant from previous post

[dash11]

The address data I pull from our system is anything BUT "nicely panned out", so your solution works perfect. Thank you!!!

[humdingaling]

Not a problem
glad it works

thanks for the rep