Insert Worksheet Name into a cell

  • Thread starter Thread starter Priti
  • Start date Start date
P

Priti

Hi,

I've been trying in vain to solve this problem.

I work with multiple worksheets and part of my title has th
worksheet's name. Right now, for each title, i edit the title
manually.

Is there any function like the = cell("filename") that extracts th
filename that can work on extracting the sheet name instead.?

Thanks in advance.

Priti
 
Hi Priti

Provided the workbook has been saved, you could use
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)
 
Is there any function like the = cell("filename") that extracts the
filename that can work on extracting the sheet name instead.?
Click to expand...

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Rgds,
Andy
 
Back
Top