| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not split... break apart?
I have a data dump, and I need to break apart the column every time a value
(*dept*) shows in the first column: finance dept bob... ssn id-no other data sally... (list of 15 more names) mfg dept joe... bill... (list of 30 more names) payroll dept lucie... (list of 4 more names) more depts with names... so i need to loop thru the first column, and have each *dept* in it's own new column or worksheet so I can print out each dept and other column info. i've had suggestions to use 'split', but I'm not using the split function - I need to break out each group of depts. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Break a link between workbooks when there is no "break" option | Excel Discussion (Misc queries) | |||
| How do I remove split a split window? | New Users to Excel | |||
| can a page break split a cell? | Excel Discussion (Misc queries) | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| How to split too long text in one row to break in next row. | Excel Discussion (Misc queries) | |||
Threaded Mode
