Is it possible to split 1 cell into 3 cells w/o affecting other ce

[Moving Mountains]

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?

 

[Gord Dibben]

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