Obtain a string from a formula that contains a link to another workbook

    I have a summary sheet that links to other workbooks. The workbooks it links to changes each week using the edit links function.


    Can you obtain a certain string from within the formula, not what's displayed in the cell, of one of the linked cells?


    My summary links to a specific folder with a date in the titel. I want to be able to extract that date and show it in a cell.


    Hope me that made sense


    thanks in advance.

    Re: Obtain a string from a formula that contains a link to another workbook


    Try the FORMULATEXT() function. You can then use such functions as LEFT(), RIGHT(), MID(), SEARCH() and FIND() to extract parts of the formula tex.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

    Re: Obtain a string from a formula that contains a link to another workbook


    That didn't work , not on excel 2013. Was able to find a custom function that worked though.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login