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.)
Hiya All
First post here, I have an excel workbook listing all my albums but they are listed into tracks
Is there a way please to remove everything after the 5th backslash as in
R:\1-9\ARTISTS ALBUMS\3.2\The Rules Have Changed\01 - One by One.mp3
to leave just
R:\1-9\ARTISTS ALBUMS\3.2\The Rules Have Changed\
I have a lot of data that I need this applying too
Regards
Steve
Hi and welcome)
Try this formula:
=LEFT(A1,FIND("~",SUBSTITUTE(A1,"\","~",5)))It will work so long as ~ is not in any of the text in the list - if the squiggle is in the text, then use a character that will never appear in the list.