Remove Every data from Specific Columns before First Semicolon from Left Side

Thanks alot Seniors....and Zbor you are awesome...Words are less to say thanks to you...I can only share my gratitude by adding reputation in your kitty..