+ Reply to Thread
Results 1 to 8 of 8

Return Sheet Name into a Cell

  1. #1
    Registered User
    Join Date
    10-24-2019
    Location
    Estonia
    MS-Off Ver
    Office 10
    Posts
    11

    Return Sheet Name into a Cell

    Hello

    What function have to use when I want see same name in excel what I use in sheet name?Book3.xlsx

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Return Sheet Name into a Cell

    A
    1
    Jaanuar

    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.

  3. #3
    Registered User
    Join Date
    10-24-2019
    Location
    Estonia
    MS-Off Ver
    Office 10
    Posts
    11

    Re: Return Sheet Name into a Cell

    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

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Return Sheet Name into a Cell

    Works.
    Get your file back (attached).
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-24-2019
    Location
    Estonia
    MS-Off Ver
    Office 10
    Posts
    11

    Re: Return Sheet Name into a Cell

    Thank you, now it is works.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,392

    Re: Return Sheet Name into a Cell

    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.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,392

    Re: Return Sheet Name into a Cell

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  8. #8
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Return Sheet Name into a Cell

    Quote Originally Posted by real20 View Post
    Thank you, now it is works.
    You welcome. Happy to help.
    Going forward (as AliGW said) when You want to use formulas from forum check what type of separator has been used and apply 'yours'.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 06-15-2018, 11:03 AM
  2. Lookup Sheet name and return cell value in that sheet.
    By llamafarmer in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-15-2016, 11:28 AM
  3. [SOLVED] Return Selected Cell to Cell A1 on Every Sheet/Tab - VBA Macros
    By Jason Carlos in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-01-2014, 08:50 PM
  4. Replies: 1
    Last Post: 08-07-2012, 03:07 PM
  5. [SOLVED] Return comment to master sheet after matching to source sheet name and cell number
    By jeffreybrown in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-21-2012, 05:09 PM
  6. copy sheet to new sheet, rename it, return cell contents
    By soldstatic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2009, 01:49 PM
  7. Indirect Formula to return Text from one sheet to cell in another sheet
    By lou031205 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2007, 02:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1