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 ':'
Sorry. My Bad. Maybe my question wasn't clear.
05/11/2017 : Agent 56: Div2: Please change the report
In this case, the column has more than two ':'. The output should be
Div2: Please change the report
The output should only eliminate text/characters before the first two ':' occurrences and ignore from the third.