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