Shortcut to split data from one column into three? HELP!

L

LenoraMarie

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!
 
D

Don Guillett

One way. Select your column or range>data>text to columns>delimited>tab &
space>>
or a macro but you don't give examples.
 
S

Stephen Lloyd

Go to Data>Text to Columns
Select the Delimited radio button
Click the relevant checkbox(s). Whatever seperates the city/state/zip. If
a comma or '/' seperates the information select the other option and then
enter whatever applies.

If there is any data in columns after the city/state/zip column you will
want to insert some empty rows to avoid erasing any data in the neighboring
columns.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split cells next to 1 cell 1
Combining three files when middle file has sections with endnotes 2
Setting column width in a table with a macro is not working 0
Two columns followed by single page-width column on same page 0
Format column widths from one table to a separate table on same page 1
Splitting contents of column into 4 3
How to center adjust text above and image in a two column document. 1
Two columns : Continuous two columns vs Parallel two Column 1

Top