VBA: right of a character and include that character

[jamescooper]

Hello, small problem:

Right(elem.innerText, Len(elem.innerText) - InStrRev(elem.innerText, " / "))

This successfully pulls right of the "/". How would I adapt to include the "/" as well?

Thanks.

 

[steve the fish]

I presume those spaces arent meant to be there around the " / " in your code? You could just add 1 eg

Right(elem.innerText, Len(elem.innerText) - InStrRev(elem.innerText, "/") + 1)

or use mid which is a bit easier

Mid(elem.innerText, InStrRev(elem.innerText, "/"), Len(elem.innerText))

 

[jamescooper]

Great solution thanks Steve!

 

[Rick Rothstein]

or use mid which is a bit easier

Mid(elem.innerText, InStrRev(elem.innerText, "/")[B][COLOR="#FF0000"], Len(elem.innerText)[/COLOR][/B])

The Mid function (in VBA) is even easier to use for the OP's request... you can leave off what I highlighted in red and it will still work the same... the Mid function returns out to the end of the text when the 3rd argument is omitted (I wish Excel's MID function did that).

 

[steve the fish]

The Mid function (in VBA) is even easier to use for the OP's request... you can leave off what I highlighted in red and it will still work the same... the Mid function returns out to the end of the text when the 3rd argument is omitted (I wish Excel's MID function did that).

Thanks Rick i wasnt aware of that.