depending on the format there are several methods.
I would try <data<text to columns first

"Cody" wrote:

I receive many spreadsheets where the sender combines the address, city,
state and zip in one cell/column. I would like to know the formula to
fragment or explode all this data into separate cells/coumns.