Breaking up a string

[Guest]

I have an "Address" field in Excel that houses Street address, City, State, &
Zip, separated only by spaces. How do I go about separating strings into New
fields for City, State, and Zip? Is there some kind of VBA code I can use to
separate the larger string?

 

[Bob Phillips]

If he has commas as he shows, he can use that as the delimiter.