View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kiklop Kiklop is offline
external usenet poster
 
Posts: 3
Default i need the sheetname in my cells

I am using numbers for sheetnames and I need them in a cell in this way
=VALUE(RIGHT(CELL("filename";A3);2))
Is there any another way to put the sheetname into the cell?