hi,
i am using below formula to extract workbook name without path
but i don't need extension (".xlsm") alsoPlease Login or Register to view this content.
above formula return = 17.2.17.xlsm
but i need
17.2.17
thanx
hi,
i am using below formula to extract workbook name without path
but i don't need extension (".xlsm") alsoPlease Login or Register to view this content.
above formula return = 17.2.17.xlsm
but i need
17.2.17
thanx
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
If the file extension is always .xlsm then use this
=SUBSTITUTE(REPLACE(LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1),1,FIND("[",CELL("filename",A1)),""),".xlsm","")
Teach me Excel VBA
Thanx for reply Bhatti ji
now result is
17.2.17
its ok
but
is it possible i format above value in date format
like
17.JAN.2017
The second month is February ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Ups! sorry @AliGW
ok
thanx a lot bhatti ji
[QUOTE=HaroonSid;4584271
ok
thanx a lot bhatti ji[/QUOTE]
You are welcome.And thanks for the rep.
Admins my post #7 in this thread needs to be deleted as it was mistakenly left blank while trying to edit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks