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'
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
get shorten worksheet name
0
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)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
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