View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Fill cell with a worksheet name?

You're welcome, thanks for the feedback.........

Vaya con Dios,
Chuck, CABGx3



"Adri S." wrote:

Beautiful! It worked. Thank you for your help!

"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3




"Adri S." wrote:

I have a workbook that will be used for employee evaluations. Each sheet is
for a different employee, and the sheet is named for the employee. I would
like the employee name, from the sheet tab, to appear in cell B1 of the
appropriate spreadsheet. For example, if the sheet tab says "Joe Smith" I
would like cell B1 to grab the name of the tab and also say "Joe Smith."

I used the formula =CELL("Filename",A1) but it gives me the entire path name
and I only want the sheet tab name. What formula will perform this function?

Thank you!