| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Isolate UNIQUE combination of Z cells from a range N that adds up | Excel Worksheet Functions | |||
| Is Access bundled in Office 2003 | Excel Discussion (Misc queries) | |||
| How do you isolate a graph from it's data? | Excel Discussion (Misc queries) | |||
| Is there a way to isolate individual cells? | Excel Worksheet Functions | |||
| how do I isolate cells to not print | New Users to Excel | |||
Linear Mode
