Hey All,
Just wondering if there is a formula I can run that will look at my cell col A1 which contains "Y:\Joinery\JOBS\2018\34AIJ_Locker\Puzzle_Locker\Locker 300x500x2100.top" but I want it to remove the filename and only show the file path, IE Y:\Joinery\JOBS\2018\34AIJ_Locker\Puzzle_Locker\
Note, The number of subdirectories will vary, I'm trying to find a way to find the first "\" inset from RHS and delete all text theirs after.
Hope that makes sense.
Last edited by AliGW; 10-09-2018 at 08:37 AM. Reason: Thread incorrectly tagged (solved) - now amended.
Try this formula
=SUBSTITUTE(A1,TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",99)),99)),"")
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
That worked perfectly, thanks for your help.
You're welcome. Glad I can offer little help
Please mark the thread as solved
For future reference, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
I have done it for you this time.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks