my data is bundled. how do I isolate in separate cells?

E

ExcelED

My data downloaded in "bundled" cells. Is there an easy/auto way to reformat
all 500 listings (delimit, I guess), rather than doing it manually. For
example, name, address and telephone number are all "stacked cells" in column
A.
 
S

Stacy C

You can use the Text to Columns option located under the Data tab.

It allows you to specify how the information will be broken up within the
new column(s).
 

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 to alphabetize data from separate cells within same row 2
how do I unmerge data in a column and distribute in rows? 7
Removing part(s) of text from downloaded data 14
Separating data in the same cell 1
How do I separate wrap text in excel spreadsheet? 2
How to Auto Reference Worksheet Tab ID's in Formulas? 9
HOW DO I COUNT CELLS WITH DATA BY COLUMN? 2
How do I select specific cells to be my tab stops? 4

Top