How I can extract the name of the sheet and pasted it in a cell?

[Luis_Carmona]

Hi, I would like to know, How I can extract the name of the sheet and pasted it in a cell, with a function? (not using Macros and VBA)

Some one can help me with this?

[#2 · Accepted solution]

@Luis_Carmona 

=TEXTAFTER(CELL("filename"),"]",-1)

Assumes the workbook has been saved.

Regards

[#3]

Thank you so much!!

If I want to chuse a sheet of the all book in accordance with the position of the sheet and then I want to put the name of that sheet in a cell of an other sheet, it can be posible?

*For example, if I want to extract the name of the last sheet that I have in a book, and put it into a cell in the first sheet of my book.

[#4]

Can we not link the all the formula cells from different sheets to a cell in your sheet1(Index)?. We must write the formula =TEXTAFTER(CELL("filename"),"]",-1) in all the sheets by simply holding the CTRL key and write the formula in the first sheet and all the other sheets will have the formula in the same location as your first sheet.

[#5]

Thank you for your reply, it help me a lot.