Hi i have this data ( Device:[Hc1 3300 Trunk1] P776 - Mecca Cash Out) in cell d3, what i need is my macro to refer to that cell and bring back the text after the dash and paste to another cell.

For example, if it had that text in d3 then the macro runs it puts just Mecca Cash Out in D2.

Thanks in advance