Writing the Sheet Name to a Cell

  • Thread starter Thread starter Ruan
  • Start date Start date
R

Ruan

Hello,

Is there a formula that will display the Sheet name in a cell?

Thanks
Ruan
 
Hello,

Is there a formula that will display the Sheet name in a cell?

Thanks
Ruan
Click to expand...

Hi Ruan,

Try this:

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


HTH,

Alan.
 
Thanks Alan. That works great.

Ruan


Alan said:
Hello,

Is there a formula that will display the Sheet name in a cell?

Thanks
Ruan
Click to expand...

Hi Ruan,

Try this:

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


HTH,

Alan.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet Function 1
Extracting First Name 12
display worksheet name in a cell 0
Info on Worksheet Size 1
"Printed by:" in Footer 5
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Finding Minimum value 4
Counting of specific Conditional Formats 3

Back
Top