Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Remove characters before :

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 ':'

Labels (2)
10 Replies
Creator III
Creator III

This is more dynamic since I don't have to mention the string 'Agent' as this is not constant. Thank you