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

Don't know if it's any better:

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

Biff

"Kiklop" wrote in message
...
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?