I created a spreadsheet with multiple columns, merged cells & formulas. I now
see that I need to split 1 cell into 3 cells within that cell in order to add
a new formula that multiplies cell #2 and cell#3 (the new added cells). I've
tried to add a column just in the selected cell, but that adds a column to
the whole worksheet.

Here's an example: Currently in the cell I have
Assistant#1 ____hrs@____$/hr.

I would like to have Assistant#1 in one cell, _____(number of hours) in the
second cell & _____($ cost per hour in the third cell) but not have it affect
any other cell, row or column in the sheet.

Is this possible?

Not possible.

Excel has lots of cells.

Stick the hours in one cell and rate in another.

In your current cell use this formula

="Assistant#1 " & X1 & "hrs @ $" & X2 & "/hr"

where X1 and X2 are hours and rate.


Gord Dibben MS Excel MVP

On Fri, 23 Oct 2009 14:31:02 -0700, Moving Mountains <Moving
wrote:

I created a spreadsheet with multiple columns, merged cells & formulas. I now
see that I need to split 1 cell into 3 cells within that cell in order to add
a new formula that multiplies cell #2 and cell#3 (the new added cells). I've
tried to add a column just in the selected cell, but that adds a column to
the whole worksheet.

Here's an example: Currently in the cell I have
Assistant#1 ____hrs@____$/hr.

I would like to have Assistant#1 in one cell, _____(number of hours) in the
second cell & _____($ cost per hour in the third cell) but not have it affect
any other cell, row or column in the sheet.

Is this possible?