I asked the following question earlier:
------------------------------------------------------------------------------------------------------------------------------
Hi -
Apologies if this has been asked before.
I have a column of text in colum A and another column of text in Column B. I'd like Column C to aggregate the two, i.e.,
Col A contents Adam
Col B contents Simmonds
Col C to read Adam Simmonds
How do I do that?
------------------------------------------------------------------------------------------------------------------------------
Now I want to add a single constant word to Col C, so that it reads Mr Adam Simmonds, where Mr is always going to be Mr.
How do I do that?
Bookmarks