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?