converting address in Excel?
I have an excel spread sheet that some prior brain trust stored the address in a single cell -
345 Oak St Anytown OH 99999
I havent looked at all the entries, but most look like there is no punctuation between the street, city, state, zip. Can I convert the space delimited address field into individual street, city, state, zip cells in a new workbook?
I am running office 2010