Deleting Content of a Cell till the End of Right (Not Row)

Thanks Mate for the advice.

I tried testing the codes but somewhere somehow it is not running. Will try to trouble shoot it.Perhaps its due to the last columns of each row might not necessarily be the same length.

Attaching my test macro file in case you like to see to check it out.