I would try copying the column to sheet2 then run it through DataText to
ColumnsDelimited by comma.


Gord Dibben MS Excel MVP

On Wed, 15 Oct 2008 12:32:04 -0700, Havenstar
wrote:

Hi,

I need to find a formula to separate the City, State, Zip onto a different
spreadsheet

Work Sheet 1
Column A
City, State, Zip

Work Sheet 2
Column A | Column B | Column C
City | State | Zip

Any help would be appreciated.

Thank you!
Havenstar