Combining formulas from difffernt cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tonso - 14 Apr 2008 14:55 GMT

I am using Excel 2002. In cell A1 I have a long formula, and in cell
A2 another long formula. How can I copy the formula in cell A2 and
then add the formula to cell A1 so it has its formula plus [+] the
formula in A2?

Thanks,

Tonso

Reply to this Message

AdamV - 14 Apr 2008 15:24 GMT

Go to the formula bar and select the formula in there, then CTRL-C to copy,
go to the other formula and paste (CTRL-V) it in where you need it (again in
the formula bar)

You could do this with keys by hitting F2 (edit in cell) Shift-Home (to
selct all content, Ctrl-C (copy), Esc (stop editing). Then Paste as usual.

> I am using Excel 2002. In cell A1 I have a long formula, and in cell
> A2 another long formula. How can I copy the formula in cell A2 and
[quoted text clipped - 4 lines]
>
> Tonso

Reply to this Message

Rate this thread: