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

Respected experts

Can you help me with a macro which delete data from Specific Columns before the Semicolon from the Left side.

Current Situation is as in table below

Company	Description	Company 2	Description 2	Company 3	Description 3
Selling	Selling; What ever we do	Crosschek	Crosschek; The waterflow	Embedded	Embedded; the Whole process

Required Situation where Column name is Description, Description2, Description 3 only in these specific columns delete data before First Semicolon from Left Side and data should look like given below

Company	Description	Company 2	Description 2	Company 3	Description 3
Selling	What ever we do	Crosschek	The waterflow	Embedded	the Whole process

Here, try this:

Please Login or Register  to view this content.

It is working,

Can you make one modification, it is actually deleting data wherever there is semicollon.

I mean let say if Column entry is
Selling; What ever we do ; I can make all change; Accordingly I work.

It should only delete data from Left side before First semicolon only and it should look like below(need to delete Selling; from the set as that is the data before first Semicolon)
What ever we do ; I can make all change; Accordingly I work.

Thanks for the help Zbor, this little tweak in code will fulfill my requirement

Try

Please Login or Register  to view this content.

OK.
Also, is there any semicolon that doesn't meant to be deleted?
In your example, does it delete First word only if it matching Company name from previous column or you want to do that in any way?

Company	Description	Company 2	Description 2	Company 3	Description 3
Selling	Selling; What ever we do	Crosschek	SOMETHING DIFFERENT; The waterflow	Embedded	Embedded; the Whole process

Actually Intention is
1) to delete data if it matches with previous column
2) And Generally in second column that data which matches with first column ends in semicolon, due to which I said only to remove data from left till First semicolon only..

Zbor actually you got hold of my core issue..Thanks for that

This maybe?

Please Login or Register  to view this content.

Great it is working..

1) Now instead of Selecting that selected column..Can I give names of all such columns where I need to apply this code?
2) Also will it be possible to add step, if Data in col "Company" is same like data in "Description" column then cell value of Description column should be empty. It should follow for all such columns Company 2 v/s Description 2, Company 3 v/s Description 3.

I apologies since English is not my first language I made it difficult to explain...But your codes are working for me..Thanks

Yes, instead of:

Please Login or Register  to view this content.

you can put:

Please Login or Register  to view this content.

Or for multiple cells:

Please Login or Register  to view this content.

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..

Glad I could Help