Separate city state and zip

OP, your example doesn't even have a state listed. Like FDibbins said, we'll need a better example (workbook preferable) that shows exactly what you are dealing with, as there are multiple methods and knowing which is best requires looking at the exact situation you are facing.