Solved

Formula to get workbook name on a cell (excel 2003)

Posted on 2011-03-16
4
323 Views
Last Modified: 2012-06-27
Thanks,
JP
0
Comment
Question by:easycapital
4 Comments
 
LVL 6

Expert Comment

by:akajohn
ID: 35149498
0
 
LVL 81

Assisted Solution

by:zorvek (Kevin Jones)
zorvek (Kevin Jones) earned 250 total points
ID: 35149512
The formula below returns the workbook file name.

   =IF(CELL("filename", A1)="","",MID(CELL("filename", A1),SEARCH("[",CELL("filename", A1))+1,SEARCH("]",CELL("filename", A1))-SEARCH("[",CELL("filename", A1))-1))

Kevin
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 250 total points
ID: 35149699
This formula should also work to get workbook name and extension

=REPLACE(LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1)&"]")-1),1,FIND("[",CELL("filename",A1)&"["),"")
0
 

Author Closing Comment

by:easycapital
ID: 35151029
Barry,

Your solution was the shortest and simplest.  Thank you Kevin as well.

Thanks,
JP
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now