Forum Discussion
Excel Copy Formula
How do you copy a formula from one workbook to another without the workbook name pasted in the formula?
5 Replies
If it's multiple formula you can highlight the range of cells to copy and press Ctrl h (replace) and replace = with '=
That turns your formula into text, copy the range of cells, paste into destination file and repeat the Ctrl h process to replace '= with =
Thank you Wyn Hopkins
Yes, it is a worksheet of multiple formulas I need to copy from one workbook to another workbook. Unfortunately, the end results adds the workbook name into the formula. Thus it does not copy the exact formula from one workbook to another.
I tested the Ctrl H with an unsuccessful result. Thank you for your advice it was greatly appreciated.
- Hi
Did you mean to write unsuccessful? i.e. it didn't work?
Hi Shaz01
If it's one formula then just double click inside the cell and highlight the formula and copy it, press Escap then go to the destination cell and paste
