When I copy a formula from one spreadsheet to another (2 different files, not
worksheets within the same file), the file name of the spreadsheet that I am
copying FROM is copied to the cell of the spreadsheet that I am copying TO. I
only want the formula itself, not the spreadsheet name. I tried PASTE
SPECIAL but it didn't work. Thanks in advance for any help.

In EXCEL 2007 when doing the Paste Special select the Formulas radio button
then hit OK and you will get just the formula without the spreadsheet name.

If my comments have helped please hit Yes.

"Gingerly" wrote:

When I copy a formula from one spreadsheet to another (2 different files, not
worksheets within the same file), the file name of the spreadsheet that I am
copying FROM is copied to the cell of the spreadsheet that I am copying TO. I
only want the formula itself, not the spreadsheet name. I tried PASTE
SPECIAL but it didn't work. Thanks in advance for any help.

I am using Excel 2003 (left that part out, sorry!)

"trip_to_tokyo" wrote:

In EXCEL 2007 when doing the Paste Special select the Formulas radio button
then hit OK and you will get just the formula without the spreadsheet name.

If my comments have helped please hit Yes.

"Gingerly" wrote:

When I copy a formula from one spreadsheet to another (2 different files, not
worksheets within the same file), the file name of the spreadsheet that I am
copying FROM is copied to the cell of the spreadsheet that I am copying TO. I
only want the formula itself, not the spreadsheet name. I tried PASTE
SPECIAL but it didn't work. Thanks in advance for any help.