One way. Select your column or rangedatatext to columnsdelimitedtab &
space
or a macro but you don't give examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"LenoraMarie" wrote in message
...
I have a large sheet of data that needs immediate work done to it so it can
be better used/searched by my boss. He now wants a column currently
containing city/state/zip into three separate columns. I'm sure there is
some way to split these into three columns without having to manually do
it
(I just don't have the time - it's a long enough list it would take three
days). But I do not know these functions (macro?) well enough. Is this
possible? Can ANYONE help me with this? I have Excel XP and there
doesn't
seem to be Microsoft Support for this product. Thanks!