Hi,
Is there a way to merge cells and keep all the contents, appended together (a reverse of "Text to Columns..."), other than by cutting and pasting the contents cell by cell?

Thanks,
Andrew

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

Attached files...

Concatenate function.xls