I have a large list of contacts in excel (well over 3000). The Adress info for each contact is all on one cell, like this:
123 Anywhere Street, New York, NY, 12345
What i need though is the street in one cell, the city in another cell, the state in another, and the zip code in another.
Just wondering if there was anyway in excel to seperate it like this without going through each Address and manually doing it. Thanks in Advance
2007-10-21
02:10:04
·
10 answers
·
asked by
Wizard of Ahhs
3