MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Splitting cells

Posted by Jonnie Flanagan on September 21, 2001 6:46 AM

I'm a housewife with limited knowledge of Excel. I can use the basics but not the bells and whistles. I'm trying to create a spreadsheet that has Mfg. names across the top, product down the side so I can do price comparisons. But I further need to split each cell of the product into "stainless" and "black" to get the two different prices for each appliance. How can I do this? Thanks, Jonnie

Posted by Ben O. on September 21, 2001 6:56 AM

You can't split cells in Excel like you can split cells of a table in Word, but you can merge the header cells of two columns to make it look like it's one column that's split down the middle. Do this by selecting the cells in the header row that you want to merge, right-clicking and selecting Format Cells, selecting the Alignment tab, and under Text Control selecting Merge.

Alternately, you could enter two values in one cell and separate them with any character you want by using an ampersand (&). For example:

="$19.99" & " / " & "$24.99"

will appear as $19.99 / $24.99 in the cell. You can't perform calculations on the values if you enter them this way, so I'd recommend merging the header cells and keeping the values in separate columns.