Hi,
I have used an excel file with multiple sheets and each sheet named by clients. I need to mention the each sheet name in A2 of the same sheet. Please help.Thanks
Hi,
I have used an excel file with multiple sheets and each sheet named by clients. I need to mention the each sheet name in A2 of the same sheet. Please help.Thanks
This question has been asked many times here and has many hits on the Net.
Please use the "search" tool.
In A1 =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,1024)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks