Help with a Formula to Print a stored variable

**Modify_inc** · 12-07-2010, 12:22 PM

Hey guys quick question for the experts here.

Is there a feature like the 'Print' feature back in BASIC programming days?

I'm trying to keep up with my taxes each year using Excel 2010, and I have named my sheets Taxes 2010, Taxes 2011, etc. at the bottom. Also each sheet or work book (I think is what you call it), the actual data on the page starts with a title at the top, PROPERTY TAXES "Year", then followed by all my nasty tax data. So anyways I would like to add the sheet name that is at the bottom to the title at the top of all my sheets\ workbooks.

EX: Print "PROPERTY " ; Sheet 1

Sheet 1 = TAXES 2010

So it would read, PROPERTY TAXES 2010

I could do that simply in BASIC, but how do I make this work in excel? I don't even see a PRINT command but then again I have much to learn and I'm excited yet overwhelmed with all that is possible in excel.

Thanks guys, and if you know a good tutorial page for getting started with basic commands in Excel point me to it. I don't want to just ask questions all the time, I want to learn as much as I can.

Can this not be done in Excel?

**Modify_inc** · 12-15-2010, 04:54 PM

Seriously no suggestions or input on this. Did I post in the wrong section? Based on what I have read and seen in this forum this should be a drop in the bucket for some of you guys!

**ChemistB** · 12-15-2010, 05:07 PM

If I understand you correctly
="PROPERTY " & =MID(CELL("Filename",A1),SEARCH("]",CELL("filename",A1))+1,50)

Does that work?

**Modify_inc** · 12-15-2010, 06:06 PM

Originally Posted by ChemistB

If I understand you correctly
="PROPERTY " & =MID(CELL("Filename",A1),SEARCH("]",CELL("filename",A1))+1,50)

Does that work?

Incredibly it does, minus a small error, but Excel corrected it. Looks like the = before MID was not needed.

="PROPERTY "&MID(CELL("Filename",A1),SEARCH("]",CELL("filename",A1))+1,50)

So the MID function extracts a string from a location and the SEARCH function specifies where to find a string location. What does the rest of this formula do, do you mind breaking it down?

Thanks again!

**ChemistB** · 12-16-2010, 09:59 AM

="PROPERTY " & =MID(CELL("Filename",A1),SEARCH("]",CELL("filename",A1))+1,50)

CELL("Filename",A1) returns the complete path to the file including workbook name (file) and sheet name.
=MID (what to look at, where to start looking, how many characters to return)
so
Look at the file path-name,
Start looking at character number (whereever it finds the "]" + 1. The "Book" name which always precedes the sheet name is bracketed in [ ].
return the next 50 characters.(I figured that would be enough)
Does that help?