Stripping The First Four Characters from a value
Hi,
What I am trying to figure out is how I can remove the first four characters
via a VBA Macro from a value of a cell.
Here's the example...
Edition = ActiveCell.FormulaR1C1 (this returns a value of "Rev XA" or "Rev
-" or "Rev 2")
What I want the macro to do is strip the "Rev " and just keep everything
from the fifth character on so I get (XA or - or 2)
Any Ideas??
Thanks In Advance,
Rob
|