Excel – Getting Worksheet Name

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

Worried you might be infected by the Conficker virus?

Just click here:

http://www.confickerworkinggroup.org/infection_test/cfeyechart.html

April 16th, 2009

Owen Pine – new site launched

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

Technorati Profile

October 13th, 2008

New blog

Having installed blogs on three other sites I thought it was about time I had my own.

They were at:

• ableSEO
• Paddle 4 Relief
• Hawkey Cleaning

I’ll be back soon, hopefully with some useful information!

July 20th, 2008