Hello:
I have Cell R2 = C:\Dropbox\Poll\1RM_Shared\Reports\NightClose\10-31-2017-TimeSheet.xls.
I need formual in cell I3 to give me just the file name 10-31-2017-TimeSheet.xls
Please let me know if you have any questions.
Thanks.
Riz
Hello:
I have Cell R2 = C:\Dropbox\Poll\1RM_Shared\Reports\NightClose\10-31-2017-TimeSheet.xls.
I need formual in cell I3 to give me just the file name 10-31-2017-TimeSheet.xls
Please let me know if you have any questions.
Thanks.
Riz
Try this:
=TRIM(RIGHT(SUBSTITUTE(R2,"\",REPT(" ",50)),50))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi,
This should do it for you.
Formula:Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Hello Glenn:
Thanks a lot, works
Riz
Try the formula
Formula:Please Login or Register to view this content.
where 150 is the max length of the string
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks