I have a filename in the format XXX-YYY-ZZZ.xls, where all the XXX and YYY and ZZZ are of variable length. Sometimes it is of the format UUU-XXX-YYY-ZZZZ.xls
I wish to delete all the characters to the left of the rightmost "-" character, including that "-" character.
Can anyone please advise which VBA string manipulation function will best do this?
regards,
Joe
I wish to delete all the characters to the left of the rightmost "-" character, including that "-" character.
Can anyone please advise which VBA string manipulation function will best do this?
regards,
Joe
Last edited: