Explode Cell Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
depending on the format there are several methods.
I would try <data><text to columns> first
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VLOOKUP to Work Two Ways 0
Seperating information in a cell 9
Splitting Text from single cell in column across multiple Columns 3
IF function that searches a range of cells for data and provide tr 2
Will Conditional Formatting work? 2
SORT REPETITIVE DATA FROM ROWS TO COLUMNS 9
Seperate Name, Street Address & City, State Zip 5
Conditional formula drop down box 4

Back
Top