merging cellscolumns text

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Merging Cells/Columns to text

Merging Cells/Columns to text

resolvedResolved · Low Priority · Version 2000

Andrew has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Merging Cells/Columns to text

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

RE: Merging Cells/Columns to text - Concatenate Function!!!

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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips


Server loaded in 0.08 secs.