{"id":5046,"date":"2017-12-19T15:29:42","date_gmt":"2017-12-19T15:29:42","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=5046"},"modified":"2023-04-23T13:28:31","modified_gmt":"2023-04-23T13:28:31","slug":"2-ways-concatenation-excel-5-examples-joining-stringscells","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/2-ways-concatenation-excel-5-examples-joining-stringscells\/","title":{"rendered":"How to Concatenate in Excel (Strings and cells)?"},"content":{"rendered":"

Generally, the information is placed in different cells in Excel sheets for better organization of data. In certain scenarios, you may require a single string that is the combined result of various cells. For example, storing First Name and Last Name in different cells.<\/p>\n

\"Excel<\/p>\n

You may require full name result combined in a single cell. This is where Excel CONCATENATE function plays its role. The CONCATENATE function combines two or more text strings (as constant literals) or from different cells and returns a single combined string.<\/p>\n

You may also use \u2018&\u2019 ampersand sign<\/strong> for concatenating string\/cells in Excel. Both CONCATENATE and \u2018&\u2019 produce the same results.<\/p>\n

Syntax of CONCATENATION function<\/strong><\/h3>\n
\n
=CONCATENATE(\"The Marks of Student \", B2, \" \",C2, \" is \", D4)<\/pre>\n<\/blockquote>\n
The above syntax shows using a text string enclosed in double quotes and various cells separated by commas. You may also use numbers without double quotes in CONCATENATE function.<\/p>\n
See the section below for various examples of using the CONCATENATE function which is followed by using \u2018&\u2019 sign.<\/p>\n
An example of combining text strings<\/strong><\/h3>\n
In the first example, I will simply join a few text strings given in the CONCATENATE function. The formula is applied in the B2 cell. Have a look at the CONCATENATE formula and result:<\/p>\n
\n
=CONCATENATE(\"An \", \"Example \", \"of \", \"CONCAT \", \"Text Strings \")<\/pre>\n<\/blockquote>\n
The result:<\/strong><\/p>\n
\"Excel<\/p>\n
The example of concatenating cells<\/strong><\/h3>\n
For the example, I will use an Excel sheet that stores student result information. The columns include Student ID, First Name, Last Name, subject marks and Total marks.<\/p>\n
By using the CONCATENATE function, I will join First Name, Last Name,\u00a0and Total as follows:<\/p>\n
\n
=CONCATENATE(\"Total marks of \", B2, \" \", C2, ,\" is \", G2)<\/pre>\n<\/blockquote>\n
The resultant sheet of data:<\/p>\n
\"Excel<\/p>\n
You can see, the C8 cell displays the concatenated result based on above formula. There, I also used space by \u201c \u201c to be used in concatenation.<\/p>\n