My database exports address like this in one cell: 122 ARRABARRI AVENUE, MT OMMANEY, QLD, 4074



I need to break them into 5 cells.

Select the column containing all the addresses, go to the Data tab and click Text to Columns button. Select data type as Delimited, click Next, select the type of delimiter as Comma and click Next, select the Destination as a new sheet or the next empty column in the worksheet so you don't overwrite your data and click Finish.

Let me know if you need more assistance.

Thank you that worked great.