Thread: Name Cell or Worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JPA JPA is offline
external usenet poster
  
Posts: 5
Default Name Cell or Worksheet
Is it possible to use the function "cell" to access only the name of the
worksheet, instead of the whole path?

Formula-- =CELL("filename";A1)
Result-- C:\My Documents\[Table.xls]Sheet2

Result expected-- Sheet2

Reply With QuoteReply With Quote