In Excel if you need to show, in a cell, the name of the worksheet use this:
First get the filename:
In Cell A1 enter =Cell(“Filename”)
The result (in a saved file) will be something like:
C:\Users\Jon\Desktop\[Book1.xls]Sheet1
To get just the worksheet:
In another cell enter =MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1))+1,32)
August 24th, 2010
Late yesterday the new site for Owen Pine was finished. If you’re in the area why don’t you pop down and see what they have to sell. My visits to the company to sort out the site for them opened my eyes to the great range of Oak and Pine furniture they have available.
March 4th, 2009
Having installed blogs on three other sites I thought it was about time I had my own.
They were at:
I’ll be back soon, hopefully with some useful information!
July 20th, 2008