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

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.

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

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

"ExcelED" wrote:

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.