I know that this is probably a no brainer for alot of you but I have fought with this thing for far too long now and it is driving me crazy.

In column A I have the path of a bunch of folders/directories. What I want to be able to do is to parse out the last folder name into a cell all by itself.

For example I have in Column A
K:\MASTER DATA BANK\INDUSTRY AFFAIRS\CORPORATE\ what I would like to do is to be able to take the word corporate and put it in a new cell. If this was only a few lines I would just retype them but I have hundreds. In some cases there are dashes (-) and underscores in the file names. I tried to find a way to search in the string from the furthest right to left to find the second occurrence of "\" and then take everything from that to the left until it finds another "\"

Any help you could offer would be greatly appreciated.