Sheet (tab) names consist of a varying number of alpha characters plus a number. The number is always the rightmost character. I want to return the sheet name without the rightmost character to use in various other ways such as VLOOKUP functions. The formula below works fine but is there a simpler way to do it?
And is there much to be gained (besides simpler reading) by naming this formula and using the name instead of the whole formula within other formulas?
=LEFT(RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))),LEN(RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))))-1)
And is there much to be gained (besides simpler reading) by naming this formula and using the name instead of the whole formula within other formulas?
=LEFT(RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))),LEN(RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename"))))-1)