Software

Ask something
Discussion Locked

Excel / 1-2-3 Query

0 helpful
3 replies

by andy1957 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

3 replies

by dklippert

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.

by andy1957

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

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

This discussion is closed to new replies.