Hi
is the value you want always at the same position?. If yes use Tom's
solution. If not you may provide some more details which substring you
want to get (that is what logic has to be applied)

--
Regards
Frank Kabel
Frankfurt, Germany


DTHMTL wrote:
Can you copy a substr of text using VBA?

123456ABC7890

I know that I can use this to copy the entire cell
Range("A1").Copy

I want to copy "ABC" and that is it. I tried using "substr"
combinations both they don't seem to work.

Thanks