Looks like we are doing someone's homework. This is the second post with
the exact same question. :)

"wjs2002" wrote in message
...
I have been given a spreadsheet with city, state and zip all in the same
cell. Is there a way to split the city, state and zip into three seperate
cells? I have a large data base and do not want to do each one at a time.