Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community
SOLVED

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

Copper Contributor

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

@Luis_Carmona 

 

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

 

Assumes the workbook has been saved.

 

Regards

 

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.

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.

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

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

@Luis_Carmona 

 

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

 

Assumes the workbook has been saved.

 

Regards

 

View solution in original post