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