Hello,

I am trying to figure out how to make a macro only copy a string of text within a cell. Luckily, it should be able to run on an easy rule. I need it to only copy everything after a ":", so I have in cell A1...

ABCD1234: Apples and Oranges

I want it to copy to only "Apples and Oranges" and paste it in cell B1.


Thanks in advance!