How do I delete the refernce a formula when copying and pasting?

  • Thread starter Thread starter Lora
  • Start date Start date
L

Lora

When I copy from one workbook to another, the reference is copied. How do I
delete
the reference part of all my formulas on a sheet? Example:

='[4trial 2008 Wkly Summary.xlsx]WklyInfoA868'!D23

I just want: =WklyInfo868!D23 to show up in the cell. I need this
to occur
for all the formulas copied on this sheet.

Suggestions!
 
In target workbook Edit>Links and change source to target workbook.

Another easy method is to do an edit>replace in the source sheet.

Replace what: =

Replace with: ^^^

Replace all.

Copy the range over to target workbook then reverse the process in both
books or just in target book and close source book without saving.


Gord Dibben MS Excel MVP
 
Back
Top