Re: Excel Help.
Hmmm... tricky. Googling did turn this up:
Quote:
Split the contents of cells across multiple cells
You cannot split a cell or range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells that was not previously merged. You can, however, divide the contents of unmerged cells and display them across other cells.
1. Select the cell, the range of cells, or the entire column that contains the text values that you want to divide across other cells. A range can be any number of rows tall, but no more than one column wide.
Important Unless there are one or more blank columns to the right of the selected column, the data to the right of the selected column will be overwritten.
2. On the Data menu, click Text to Columns.
3. Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into columns.
Note For help with completing all the steps of the wizard, click Help Button image in the Convert to Text Columns Wizard.
|
Give that a shot...
__________________
*B*
Save Early, Save Often Save Before, Save After
Two-Star General, Spelling Soldiers
-+-+-+
Give 'em a hug one more time. It might be the last.
|