For automating some editing, it would be very useful to me to get in a cell
of an excel worksheet the name of the sheet. Is there any function or
mechanismo to get it?

Thanks,

Hi Jordi,

Pls try this

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

"Jordi" wrote:

For automating some editing, it would be very useful to me to get in a cell
of an excel worksheet the name of the sheet. Is there any function or
mechanismo to get it?

Thanks,

Thank you very much for your help, it worked!!!

"Anirudh" wrote:

Hi Jordi,

Pls try this

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

"Jordi" wrote:

For automating some editing, it would be very useful to me to get in a cell
of an excel worksheet the name of the sheet. Is there any function or
mechanismo to get it?

Thanks,

You're welcome
Thanks for the feedback


"Jordi" wrote:

Thank you very much for your help, it worked!!!

"Anirudh" wrote:

Hi Jordi,

Pls try this

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

"Jordi" wrote:

For automating some editing, it would be very useful to me to get in a cell
of an excel worksheet the name of the sheet. Is there any function or
mechanismo to get it?

Thanks,