{"id":2080,"date":"2015-02-10T09:29:45","date_gmt":"2015-02-10T09:29:45","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/?p=2080"},"modified":"2026-01-02T05:59:50","modified_gmt":"2026-01-02T05:59:50","slug":"using-the-concatenate-function-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/using-the-concatenate-function-in-excel\/","title":{"rendered":"Using the Concatenate Function in Excel"},"content":{"rendered":"

The concatenate\u00a0function quickly links\u00a0the content of two or more cells<\/h2>\n

The concatenate function in Excel allows you to join text strings from different cells (like first name and last name) which can be very useful. It can be used with a number of other Excel functions. These are the sorts of tips and hints you can pick up on our Excel training courses London (or online if you prefer)<\/a>.<\/p>\n

You can concatenate in Excel by using the Concatenate function or use &.\u00a0<\/strong>First we will have a look at the\u00a0Concatenate\u00a0function.<\/p>\n

Step 1<\/strong> Select the cell in which you want to concatenate text strings. You can type the formula\u00a0=concatenate(B3,” “,C3)\u00a0<\/strong>and click\u00a0OK<\/strong>. You can also open the function dialogue box shown below and add the information.<\/p>\n

\"concatenate1\"<\/a><\/p>\n

Step 2 \u00a0<\/strong>Click OK and the text string will be concatenated. If you need a blank space between two text strings you can do it by using ” ” \u00a0(quotation mark + space +\u00a0quotation mark) for one of the text values (see example above).<\/span><\/p>\n

You can also concatenate text strings by selecting the cell where you want text strings to be concatenated and type = the cell reference & ” ” & the second cell reference & ” ” & the third cell reference etc.<\/p>\n

\"concatenate<\/a><\/p>\n

Nest the concatenate function in other useful functions.<\/strong><\/h3>\n

If you work with the VLOOKUP function\u00a0you may need to lookup a\u00a0value based on information from two or more cells then you can just nest the Concatenate function in the VLOOKUP\u00a0function or if you want to test values from two cells in an\u00a0If<\/strong>\u00a0function you again can concatenate values from the two cells.<\/p>\n

In the example below the full name needs to be tested in an\u00a0IF\u00a0<\/strong>function. The Concatenate <\/strong>function is nested in the\u00a0Logical_Test\u00a0<\/strong>in the IF\u00a0<\/strong>function.<\/p>\n

\"concatenate<\/a><\/p>\n

In the example below the full name needs to be\u00a0found in the commission table to return the correct commission rate.. The\u00a0Concatenate\u00a0<\/strong>function is nested in the\u00a0Lookup_Value\u00a0<\/strong>in a VLOOKUP\u00a0<\/strong>function.<\/p>\n

\"concatenate<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

The concatenate\u00a0function quickly links\u00a0the content of two or more cells The concatenate function in Excel allows you to join text strings from different cells (like first name and last name) which can be very useful. It can be used with a number of other Excel functions. These are the sorts of tips and hints you […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"singular-low-link.php","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,6],"tags":[106,107,189,326,327],"class_list":["post-2080","post","type-post","status-publish","format-standard","hentry","category-excel-training","category-hints-tips","tag-concatenate-function","tag-concatenation","tag-excel-concatenate-function","tag-joining-first-name-and-last-name","tag-joining-two-or-more-text-strings"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2080","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=2080"}],"version-history":[{"count":2,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2080\/revisions"}],"predecessor-version":[{"id":7830,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2080\/revisions\/7830"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=2080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=2080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=2080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}