any function or mechanism to get in a cell the name of the sheet?

[Guest]

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,

 

[Guest]

Hi Jordi,

Pls try this

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

 

[Guest]

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

Hi Jordi,

Pls try this

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

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,

 

[Guest]

You're welcome
Thanks for the feedback

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

Hi Jordi,

Pls try this

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

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,