Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
splitting one column into two columns ... not what you think
i have fixed column widths that can't be changed; nor can any other columns
be added to the worksheet ... i've got data in one column that represents "results" ... within the results column though, i need two columns (starting directly below the "results" cell, one that reads "in range" and that other that reads "out of range" ... so: if i'm on [column a] [cell 1] i want: "results" ... in [column a] [cell 2] i want: "in range" AND "out of range" with a line down the middle. "text to column" is not what i want here ... at least i've tried that and i come up with 2 separate columns ... I WANT ONE COLUMN WIDTH THAT'S DIVIDED BY A SINGLE LINE. please help! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
splitting one column into two columns ... not what you think
You cannot split a column into two columns.
You could dork about with the drawing toolbar and draw a line between the words in a cell but that's a lotta fiddly work. You could use the "Pipe" symbol between the words? But, if you can't change column widths or add more columns you are kinda stuck. Gord Dibben MS Excel MVP On Thu, 22 Jan 2009 16:33:01 -0800, umn wrote: i have fixed column widths that can't be changed; nor can any other columns be added to the worksheet ... i've got data in one column that represents "results" ... within the results column though, i need two columns (starting directly below the "results" cell, one that reads "in range" and that other that reads "out of range" ... so: if i'm on [column a] [cell 1] i want: "results" ... in [column a] [cell 2] i want: "in range" AND "out of range" with a line down the middle. "text to column" is not what i want here ... at least i've tried that and i come up with 2 separate columns ... I WANT ONE COLUMN WIDTH THAT'S DIVIDED BY A SINGLE LINE. please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting a multi-column table in single columns | Excel Discussion (Misc queries) | |||
Splitting Column in to 2 columns | Excel Discussion (Misc queries) | |||
Splitting one column into multiple columns | Excel Worksheet Functions | |||
splitting 1 column of data into multiple columns | Setting up and Configuration of Excel | |||
Splitting text in one column into two (or more) columns. | Excel Worksheet Functions |