Combining the Contents of Two Cells in MS Excel

From Larry David Long July 25th, 2016

36 plays 0 comments

This video describes the use of =concatenate() and the & in MS Excel. Presented by Larry Long, Management Analyst. ldlong@msu.edu.

Sample Formulas:
Using =Concatenate()

=CONCATENATE("Text1", "Text2")
=CONCATENATE(A1, B1)

Using &

="Text1"&"Text2"
=A1&B1

Tags: ms excelconcatenate

Appears In: Public Media

Comments
Related Media

Add a comment

Combining the Contents of Two Cells in MS Excel

Related Media