Separating Addresses in EXCEL

Microsoft Office excel 2007 home & stude...
July 1, 2010 at 13:34:59
Specs: Windows XP
Hi, I have 300 customer addresses in excel. But I typed the full address, Street number, street name, city, state and zip into one box. Can i separate so each are in their own column? Thank you.

See More: Separating Addresses in EXCEL

July 1, 2010 at 14:31:31
Try Data...Text to Columns...delimited by a space (I assume)

If that doesn't work, you'll need to provide some more information about how the addresses are laid out in the cells.

Report •
Related Solutions

Ask Question