Ask Your Question
0

Tab name in a document

asked 2017-06-19 08:32:00 +0200

cwk gravatar image

I have a template that came from M$ that includes the following string:

=RIGHT(CELL("Filename",A1),LEN(CELL("Filename",A1))-FIND("]",CELL("Filename",A1)))

That string in Excel translates to a cell name given as the year and a sequential number. Generally I can parse even pretty arcane language, but this one I just don't get. It definitely doesn't work in Calc, but I'm more concerned with replicating the functionality than with the arcana of VBasic. Any ideas?

edit retag flag offensive close merge delete

Comments

The formula takes trailing part of current file name (after "]"). See here and here.

As you didn't give any information about your files naming scheme, as well as a sample expected output (aside of textual free-form description), it's difficult to advise. Just note that Excel doesn't mean sheet number for "Filename" func.

Mike Kaganski gravatar imageMike Kaganski ( 2017-06-19 08:58:45 +0200 )edit

I had to get on a work computer with Excel installed to make it work. Here's what it shows:

https://www.dropbox.com/s/vqg6tqfv3y4...https://www.dropbox.com/s/muwgv2adsen...https://www.dropbox.com/s/pxzq2zoy323...

All of the tabs are in a single file named "My Name Invoice.xlsx" The tabs are named manually.:

https://www.dropbox.com/sh/hiusen9qpx...

Wish I knew the name of the site I stole it from!

cwk gravatar imagecwk ( 2017-06-20 02:10:27 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2017-06-20 14:57:38 +0200

JohnSUN gravatar image
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-06-19 08:32:00 +0200

Seen: 37 times

Last updated: 2 days ago