+ Reply to Thread
Results 1 to 2 of 2

formula for naming cell after tab

Hybrid View

ammartino44 formula for naming cell after... 08-13-2015, 01:04 PM
FDibbins Re: formula for naming cell... 08-13-2015, 01:11 PM
  1. 08-13-2015, 01:04 PM #1
    ammartino44 is offline
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    formula for naming cell after tab

    Hello. Is there a formula for getting tab name in a cell without vba?
    Reply With QuoteRegister To Reply
  2. 08-13-2015, 01:11 PM #2
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: formula for naming cell after tab

    Try this...
    =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Folder naming + File naming
    By Frozt15 in forum Excel General
    Replies: 2
    Last Post: 07-23-2012, 04:52 AM
  2. Naming an array formula
    By Sleette in forum Excel General
    Replies: 9
    Last Post: 06-03-2010, 12:43 AM
  3. Incorporate Adjacent Cell in Formula w/o Naming Cell Address?
    By cyberphonics in forum Excel General
    Replies: 9
    Last Post: 10-04-2009, 10:28 AM
  4. Naming Formula: Last, First to First Last
    By njexpress9 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-22-2009, 04:28 PM
  5. Formula for naming tabs
    By mremmenga in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2008, 03:40 PM
  6. naming a column & naming a cell with a number
    By evanzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2008, 10:49 PM
  7. Cell Naming
    By Grymjack in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2006, 02:10 PM
  8. [SOLVED] Naming a cell
    By mike in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2005, 08:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1