The function should "read" the characters in a cell Right-to-Left, searching for a particular sequence. In my case the sequence is kay-space-semicolon. In other words...

; K (left to right)

or

K ; (if read right to left)

The function would eliminate everything left of the K (including the semicolon and the space) when this sequence is found. If the sequence is not found, the cell remains as normal.

Example:

*as;lk djf 83; K;lasd K*would return

*K;lasd K*

Any help would be appreciated. Thank you.