Right side of a particular keyword in a string/text on Excel

=RIGHT(A2,LEN(A2)-SEARCH("Keyword",A2))

Add Comment