SHOP PRODUCTS
Houzz Logo Print
caliloo_gw

converting address in Excel?

caliloo
11 years ago

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

Thanks

Alexa

Comments (3)