Share via

replace cell with file name

Anonymous
2011-04-21T18:04:06+00:00

I have this formula for matching a cell on the page to the tab name but every time I go to use it in a different book I come up with "value" is so frustrating.. tells me there is a constant in the formula.. I cannot figure it out.. the formula is =REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-04-21T18:17:19+00:00

Hi,

If you use that in a new workbook then it will return a #VALUE error until the workbook has been saved.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-04-21T18:27:37+00:00

    thank you this is awesome to know!!

    Was this answer helpful?

    0 comments