Read column right-to-left

[tvisgod]

I'm hoping for help crafting a function to apply to all the cells (containing entries of various lengths) in a column.
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.

 

[tvisgod]

=IF(COUNTIF(A1,"*; K*"),"K"&TRIM(LEFT(RIGHT(SUBSTITUTE(A1,"; K",REPT(" ",200)),200),200)),A1)

The above function is working great for me. Is there any way to incorporate another step? After this function has been applied (everything left of the last K sequence has been removed), I'd like to remove any remaining sequences in the string that begin with a semicolon.

For example, if after applying the above function, I'm left with a string like this:
K2837 .b80 830; jsf9 kdf 9h. ajsdf0
I'd like to adjust the function so it eliminates ; jsf9 kdf 9h. ajsdf0 and leaves K2837 .b80 830

Should I just do this as a separate function? Or is there a way to incorporate it into =IF(COUNTIF(A1,"*; K*"),"K"&TRIM(LEFT(RIGHT(SUBSTITUTE(A1,"; K",REPT(" ",200)),200),200)),A1)