Can you also tell me how to do the following.......... which I know should be super easy I'm assuming.

I want to consolidate / join / "add" two text columns together so that a 3rd column contains all the data of the first two columns.

For the life of me I can't figure this out. I would think Excel would have a simple way to do this. I might try to do it with an Index function although it seems like there should be an easier way.

By the way, I'm looking for this to be dynamic so if either Column A or B change then Column C is updated without having to do anything.

This will be my last question.