I have Column - Data that has values in the format below
10/25/2015 : Agent1: This is the right value
05/11/2017 : Agent 56: Please change the report
I need to remove everything before the second ':' and only show the text in my output.
This is the right value |
Please change the report |
How do I do this in the expression or Script? I tried =Mid(Data, Index(Data, ': ')+2) but this only removes text before the first ':'
This is more dynamic since I don't have to mention the string 'Agent' as this is not constant. Thank you