I would like to find the position of the last occurrence of a character in a string. For example, I have a string with the following: "c:\wwgpeTool\bids\Test File.GP$". I would like to find out the position of the last '\' in the string because I want to pull the filename, 'Test File.GP$' into a variable. I would like to avoid writing code to do this. Are there some Excel functions I can use for this?
Bookmarks