Excel 2007 : Dividing an address into two columns

[cattleman]

I am running for a local political office, and have put together a walking list of registered voters so that I can campaign door-to-door based on information sent to me by our Secretary of State's office. It is well organized, with each voter's address broken down column-by-column by County, then city, then address. I would like to break it down one step further by putting street names and individual address numbers into two separate columns to make going door-to-door easier. I have figured out how to do this manually, one by one, but would like to avoid having to use that method for 3500 people. If anyone can suggest anything, I would be extremely grateful!

[oeldere]

Use text to collumn (excel 2007) => data => text to collumn

[cattleman]

Thank you very very much! Your advice was immensely helpful to me.