Combining the Contents of Two Cells in MS Excel

From Larry David Long on July 25th, 2016

views 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

Combining the Contents of Two Cells in MS Excel

Related Media