Ask Your Question
0

Tab name in a document [closed]

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

cwk gravatar image

updated 2020-07-20 12:46:15 +0100

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-20 12:47:29.518835

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 +0100 )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 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

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

JohnSUN gravatar image
edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 113 times

Last updated: Jun 20 '17