Merging Cells/Columns to text

Dear Andrew

Thank you attending Excel Advanced and VBA courses. I hope you enjoyed the training and benefited from them.

There is a function called Concatenate that should be able to resolve your query:

The following is the Syntax:

CONCATENATE (text1,text2,...)

You can either type this starting with an = sign or use the Function from the fx button.

The main important thing to remember is to type in " " in input areas if you want a space bar between the two separate text.

Please refer to the attached file with this post for an example. I have save the file in Formula view for your convenience but you can press the shortcut key CTRL +`( this key is located just below the Esc key on the keyboard) to see the result view on the cells.


I hope this answers your query!!

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!


Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003