Homework?

"whs2002" <whs2002@discussions.microsoft.com> wrote in message
news:F7F6FAD1-095E-46E3-9D7B-CD7F9F8254B9@microsoft.com...
I ha ve been given a large data base with city, state and zip in same cell.
How can I seperate the city, state and zip without doing it manually?