Text right of : from a cell

You could use this formula:

Formula:

=RIGHT(F1,LEN(F1)-FIND("|",SUBSTITUTE(F1,":","|",LEN(F1)-LEN(SUBSTITUTE(F1,":","")))))

Or you could use a small UDF:

Function RightText(ByVal MyText As String, MyCharacter As String)
    RightText = Right(MyText, Len(MyText) - InStrRev(MyText, MyCharacter))
End Function

Which can be used as:

Formula:

=RightText(F1,":")