Breaking up a column

  • Thread starter Thread starter Dig
  • Start date Start date
D

Dig

Is there a simple to way to extract field data to insert in their own field?

I have a list with the City, State and Zip in one column as follows:
Erving, MA 01344

Is there a way to extract the City an put it into a seperate column?
So I can end up with the City State and zip in their own columns.

Thanks
 
Try Data -- Text to Columns (Delimited, Delimiters = Comma *and* Space,
Finish).

You'll need to make sure you have a couple of blank columns to the right of
your list.

HTH,
Andy
 
Nevermind I figured it out.

I placed the column in Word and used find and replace to insert "," using
the comma after the city as the find. I then used convert text to table
which gave me 2 colums I then cut the city column and inserted into my Excel
file.

I then went back to Word and did a find and replace using the blank between
the state and zip and followed the steps above and within a few seconds it
was done.

Thanks
 
Back
Top