Any way to import a tab name into a cell such that the cell text is the same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

Try this:

B2: =MID(CELL("filename"),SEARCH("]",CELL("filename"))+1,255)

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"Al" wrote:

Any way to import a tab name into a cell such that the cell text is the same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

This will work only if the file has been saved
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Al" wrote in message
...
Any way to import a tab name into a cell such that the cell text is the
same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

Hi Al

Try
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)


The file must be saved first.



--
Regards
Roger Govier



"Al" wrote in message
...
Any way to import a tab name into a cell such that the cell text is the
same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))
--
David Biddulph

"Al" wrote in message
...
Any way to import a tab name into a cell such that the cell text is the
same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

These both work...many thanks to you. I'm now reading up on MID and FIND
functions, but could you please explain what your functions are actually
doing. Thanks in advance!

"Bernard Liengme" wrote:

This will work only if the file has been saved
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Al" wrote in message
...
Any way to import a tab name into a cell such that the cell text is the
same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99)

Vaya con Dios,
Chuck, CABGx3



"Al" wrote:

Any way to import a tab name into a cell such that the cell text is the same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

Type the formula =CELL("FILENAME"), OR =CELL("FILENAME",A1) in a cell and see
that it returns the entire PATH, Workbook name, and sheet name. The formula
sees this string each time those terms are used in it. Essentially the
formula says to find the closing bracket symbol "]", skip over it, and return
the rest of the characters in the string (ie: the sheetname)

hth
Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99)

Vaya con Dios,
Chuck, CABGx3



"Al" wrote:

Any way to import a tab name into a cell such that the cell text is the same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

If you want to find out what an Excel function does, put the function name
into Excel's help. It will tell you the syntax, show examples, and often
cross-refer to related functions too.
--
David Biddulph

"Al" wrote in message
...
These both work...many thanks to you. I'm now reading up on MID and FIND
functions, but could you please explain what your functions are actually
doing. Thanks in advance!

"Bernard Liengme" wrote:

This will work only if the file has been saved
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
best wishes

"Al" wrote in message
...
Any way to import a tab name into a cell such that the cell text is the
same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

Or (more robustly)
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1)))--David Biddulph"David Biddulph" <groups [at] biddulph.org.uk wrote in ... =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))) "Al" wrote in ... Any way to import a tab name into a cell such that the cell text is thesame as the tab? (Tab name = Project ABC, and I'd like to automatically set cell B2 to "Project ABC") Allan

Be careful with the formulas that didn't include a reference to a cell in the
sheet.

=CELL("filename")

will return the name of the workbook that is active when excel recalcs. If you
open two different workbooks and arrang windows so you can a worksheet from each
workbook and put that =CELL("filename") in a cell in each workbook, you'll see
the problem.

In this case, you'd want to include a reference to the worksheet that contains
the formula. You can use:

=CELL("filename",a1)
or even use the cell that contains the formula.

Al wrote:

Any way to import a tab name into a cell such that the cell text is the same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

--

Dave Peterson

Good point Dave............I keep forgetting that......probably I need to
increase the strength of my medication <g

Vaya con Dios,
Chuck, CABGx3



"Dave Peterson" wrote:

Be careful with the formulas that didn't include a reference to a cell in the
sheet.

=CELL("filename")

will return the name of the workbook that is active when excel recalcs. If you
open two different workbooks and arrang windows so you can a worksheet from each
workbook and put that =CELL("filename") in a cell in each workbook, you'll see
the problem.

In this case, you'd want to include a reference to the worksheet that contains
the formula. You can use:

=CELL("filename",a1)
or even use the cell that contains the formula.

Al wrote:

Any way to import a tab name into a cell such that the cell text is the same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

--

Dave Peterson

Or reduce it <vbg????

CLR wrote:

Good point Dave............I keep forgetting that......probably I need to
increase the strength of my medication <g

Vaya con Dios,
Chuck, CABGx3

"Dave Peterson" wrote:

Be careful with the formulas that didn't include a reference to a cell in the
sheet.

=CELL("filename")

will return the name of the workbook that is active when excel recalcs. If you
open two different workbooks and arrang windows so you can a worksheet from each
workbook and put that =CELL("filename") in a cell in each workbook, you'll see
the problem.

In this case, you'd want to include a reference to the worksheet that contains
the formula. You can use:

=CELL("filename",a1)
or even use the cell that contains the formula.

Al wrote:

Any way to import a tab name into a cell such that the cell text is the same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan

--

Dave Peterson


--

Dave Peterson

Thanks for the explanation...reading the HELP doesn't "explain" what's going
on to us non-experts! (Love this discussion group...keep up the good work!)

"CLR" wrote:

Type the formula =CELL("FILENAME"), OR =CELL("FILENAME",A1) in a cell and see
that it returns the entire PATH, Workbook name, and sheet name. The formula
sees this string each time those terms are used in it. Essentially the
formula says to find the closing bracket symbol "]", skip over it, and return
the rest of the characters in the string (ie: the sheetname)

hth
Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

=MID(CELL("filename"),FIND("]",CELL("filename"),1)+1,99)

Vaya con Dios,
Chuck, CABGx3



"Al" wrote:

Any way to import a tab name into a cell such that the cell text is the same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan