get shorten worksheet name

0

i know to use the following to get the worksheet name

formula  =MID(CELL("filename",G4),FIND("]",CELL("filename",G4))+1,256)

but i want the name after the symbol '.' [ignore the ' ']

such as 'dropdown.test' into just 'test'

Answer
Discuss

Answers

0
Selected Answer

It's the solution you already have but applied to the result.

=MID(MID(CELL("filename",G4),FIND("]",CELL("filename",G4))+1,256),FIND(".",MID(CELL("filename",G4),FIND("]",CELL("filename",G4))+1,256))+1,256)
Discuss

Discussion

it worked
I've been using a work-around that included using =RIGHT(G4,LEN(G4)-FIND(".",G4))   I just got on a 'tare' to see if I could get the same answer but in just one step

THANKS
KDS1489 (rep: 6) Nov 2, '19 at 8:20 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login