Results 1 to 10 of 10

Thread: Extracting the sheet name only (as a string) from a formula to another cell

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-19-2013, 02:48 PM #1
    aperrin8
    aperrin8 is offline
    Junior Member
    Join Date
    Aug 2013
    Posts
    1
    Rep Power
    0

    Extracting the sheet name only (as a string) from a formula to another cell

    Hi there

    I am trying to extract the name of the sheet that is referenced in another cell as a string.

    e.g. the formula in A1 is ='Valuation tables'!A52

    I would like A2 to display 'Valuation tables'

    Is that possible? I have been searching for a while now, unsuccessfully. I guess there is a trick using INDIRECT and CELL but I can't work it out.

    Thank you for your help!

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgNsaS3Lp1
    https://www.youtube.com/watch?v=QjEWAJ3d-jw&lc=UgxJLVpwY8fIla7G-pN4AaABAg.9BLeCWVhxdG9wgR1EPUkhw
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 11-20-2023 at 03:58 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Highlighting All the Cells of Active sheet which contains a particular String:
    By littleiitin in forum Excel and VBA Tips and Tricks
    Replies: 6
    Last Post: 10-18-2013, 04:19 PM
  2. Extracting Custom Pattern Consisting of Numbers & Text From Alphanumeric String
    By larkspur in forum Excel Help
    Replies: 14
    Last Post: 05-25-2013, 06:55 AM
  3. Copy Sheet name to Cell without Updating the other Sheet
    By Ryan_Bernal in forum Excel Help
    Replies: 1
    Last Post: 02-10-2013, 06:21 PM
  4. require formula help to copy data from sheet to sheet
    By Terry in forum Excel Help
    Replies: 2
    Last Post: 12-26-2012, 08:31 AM
  5. Find Color in the string using formula.
    By LalitPandey87 in forum Excel Help
    Replies: 4
    Last Post: 07-10-2012, 09:16 PM

Tags for this Thread

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