Splitting rows into individual columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have multiple rows that contain address information such as the following:

420 Main St
Grafton, OH 44044

18 E Jefferson St
Jefferson, OH 44047

I need to split the Address, City, State and Zip Code into separate columns
or rows so that it looks like the following:

420 Main St. Grafton, OH 44044
18 E. Jefferson St. Jefferson, OH 44047

Is this possible in Excel 2003?
 
Thanks so much for your reply. This would work EXCEPT for the following:
1) Whenever I have an address with St. in it, it puts it into the same
column as the City.
2) I have over 3,000 rows that I need to convert. It does not appear that I
can convert all of these cells at the same time.
 

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

proper formula - how to make the state be CAPS 2
Mailing address block: sorting 1 row to columns 1
Splitting cells with significant variances from row to row 2
Transpose list of address into rows for mailing list 6
Text and Numeric lookup 5
Parsing line breaks into separate cells 3
Insert Cells every other row 1
Offset function with inconsisent data location 1

Back
Top