Thread: How the heck?
View Single Post
  #6   Report Post  
Old April 8th 08, 02:44 AM posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,388
Default How the heck?

Yes, thank-you. I like to understand what I use. Thanks for taking the effort.
Dave.

"BoniM" wrote:

The Cell function returns information about the given cell, if the info type
(first argument) of filename is requested, the returned info is the complete
path to that cell - for example:
C:\Users\UserName\Documents\[sample.xlsx]Sheet1

The Find function is looking for the first instance of a right square
bracket in the filename info, which indicates the end of the workbook name,
and returns its character position

The Mid function is therefore taking the location of the ] in the path to
the current cell, and starting in the next position, returning up to the next
255 characters, which will be your sheetname.

Does that help?


"Dave" wrote:

Could someone please explain to me how the following function works?

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

Many thanks - Dave.