VBA to leave only content in string after last “/“ character.

[dugweje]

Hello.

I have an excel file I download that has columns with cell contents that look like this: /great/chicken/sautéed/AA41. I want only the “AA41” left with everything beforehand deleted. The columns are H:1-H:2000. For extra reference there are always 9 “/“ characters so it would always be the only content after the 9th “/“ that is wanted. Thank you.

 

[johnnyL]

I liked your code @Peter_SSs. Don't feel bad.

 

[Peter_SSs]

Don't feel bad.

I don't feel bad and the OP is perfectly entitled to choose the method they want, but I was wondering if they investigated all the suggestions before choosing.