General discussion

Locked

Excel / 1-2-3 Query

By Andy1957 ·
In Lotus 1-2-3, I used the @cell("sheetname",cell ref) function a lot.

What is the equivalent function in Excel as there is no equivalent to the "sheetname" argument in Excel's CELL function?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel / 1-2-3 Query

by DKlippert In reply to Excel / 1-2-3 Query

Cell, of course give the full path including the Sheet name (=Cell("Filename",A!)). To get just the file name, try this formula:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))
See www.cpearson.com/excel/excelF.htm
There are some other formulas at the bottom of the page.

Collapse -

Excel / 1-2-3 Query

by Andy1957 In reply to Excel / 1-2-3 Query

A quick answer like this is precisely why I use TechRepublic.

Thanks for the web site address too. It looks very useful.

Collapse -

Excel / 1-2-3 Query

by Andy1957 In reply to Excel / 1-2-3 Query

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums