Explode Cell Data

C

Cody

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.
 
B

bj

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