Formula for Worksheet Name

AlexN

New Member
Joined
Apr 8, 2002
Messages
7
Hi,
is it possible to put a simple formula in a cell to show the name of a worksheet.

Thanks for your help
Alex
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
L

Legacy 51064

Guest
=RIGHT(CELL("FILENAME"),LEN(CELL("FILENAME"))-FIND("]",CELL("FILENAME")))
 
L

Legacy 51064

Guest

ADVERTISEMENT

Good point Barrie! If you have mutliple sheets open, then the value will change as well.
 

AlexN

New Member
Joined
Apr 8, 2002
Messages
7
Yeah I just noticed that. Am just trying to work that out now as I need this to give me the name for each individual worksheet all in the same file!
 

Barrie Davidson

MrExcel MVP
Joined
Feb 10, 2002
Messages
2,330
You can get around that by slightly changing the formula to:

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

Regards,
 

Watch MrExcel Video

Forum statistics

Threads
1,118,046
Messages
5,569,859
Members
412,298
Latest member
dietitiann
Top