Excel macro

Hello. I am looking to create a macro in excel that will combine text from one cell to the adjacent cell and then delelte and shift cells left for the copied cell. 

For instance: Cell A1 contains “One”, B1 contains “Two”. and C1 contains “Three”. 

Using a macro, I wand cell A1 to contain “OneTwo”, B1 to contain “Three”, and C1 to contain whatever is in the adjacent cell and so on. 

Can someone help me write a macro for this? 

Thank you very much

Michael

By: Michael

Leave a Reply

Your email address will not be published. Required fields are marked *