copy formula from worksheet to worksheet

  • Thread starter Thread starter Ron B
  • Start date Start date
R

Ron B

When I copy formulas from one worksheet to another the
pasted formula includes the path and file name of the
worksheet it was copied from.

At times I can edit it out, but sometimes the formulas
get to long and are cut.

How can I copy and paste without the path and file name
in the formula.

Thanks for any help
 
One way

Use Edit>Replace

Replace "=" with " =", which converts formulas to text.

copy and paste the cells

Use Edit/Replace then to replace " =" with "=" To make them formulas again
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying template from one worksheet to another 2
Copying Formulas 2
Copy same formula to all worksheets in a workbook 1
Array 3
copy formulas from one worksheet to an entirely different workshee 2
Copy worksheet to new doc w/formulas not referencing previous doc 4
Copy Worksheet 1
Copied info from Excel worksheet, but pasted info won't work in fo 3

Back
Top