How to get a particular part of a String
- by Harish
I am writing a macro in Excel where I need to get a substring from a String.
Its like this.
~/tester/test/hai/bye
~/stack/overflow/hai/bye
In the above cases I need to take the String tester from the first one and stack from the second one.I tried using the Instr but its not useful.Can anyone help this?