Hello,
I have data that looks like this:
blahblah-need
blah-aneed
blahblahblah-aaneed
I would like to have everything right of the dash to get:
need
aneed
aaneed
I have used mid and instr to get the left hand stuff. I've tried to modify to get the data to the right of the dash and I am lost.
Your help appreciated.
I have data that looks like this:
blahblah-need
blah-aneed
blahblahblah-aaneed
I would like to have everything right of the dash to get:
need
aneed
aaneed
I have used mid and instr to get the left hand stuff. I've tried to modify to get the data to the right of the dash and I am lost.
Your help appreciated.