SOLVED

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

Copper Contributor

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

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?

4 Replies
best response confirmed by Luis_Carmona (Copper Contributor)
Solution

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

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

Assumes the workbook has been saved.

Regards

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

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.

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

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.

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

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

Accepted Solutions
best response confirmed by Luis_Carmona (Copper Contributor)
Solution

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

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

Assumes the workbook has been saved.

Regards