Hello
What function have to use when I want see same name in excel what I use in sheet name?Book3.xlsx
Hello
What function have to use when I want see same name in excel what I use in sheet name?Book3.xlsx
A 1Jaanuar
A 1=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
Sheet: Jaanuar
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Thank you, but this is not work.
Not trying to type a formula?
When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula:
• you type: =1+1, cell shows: 2
To get around this, type an apostrophe ( ' ) first:
• you type: '=1+1, cell shows: =1+1
Works.
Get your file back (attached).
Thank you, now it is works.
It always worked, but in your locale (European in Estonia), you need semi-colons ( ; ) instead of commas ( , ).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks