Syntax<\/h3>\n
CONCAT(value1, value2)<\/strong><\/p>\n Please note that both\u00a0<\/span>value1<\/strong>\u00a0<\/span>and\u00a0<\/span>value2<\/strong>\u00a0<\/span>can be any value or reference to a value, including numeric and text types. But it isn\u2019t a good idea to include ranges that have more than one values within them.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Let us now go ahead and look at a few examples that we tried on Google Sheets application. Please take a look at the following snapshot.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/CONCAT-formula-Illustration-Frame-1.png” alt=”CONCAT formula in Google Sheets: Usage” title_text=”concat-formula-usage” align=”center” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Across all the examples, we\u2019ll notice that the CONCAT formula appends the second value after the first. Regardless of whether the values are text or numeric. The functionality of this formula is the same as that of the ampersand (&) operator. We can achieve the same results using this operator. Please see the image below.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/CONCAT-formula-Illustration-Frame-2.png” alt=”CONCAT formula in Google Sheets” title_text=”concat-formula” align=”center” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There\u2019s a limitation to the CONCAT formula \u2013 in that we can only append two values together. To that effect, it won\u2019t give us the desired output if we supplied a range of values to its input parameters. It might result in an error as shown below.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/CONCAT-formula-Illustration-Frame-3.png” alt=”CONCAT Formula in Google Sheets: Error Message” title_text=”concat-formula-error-message” align=”center” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Or surprisingly, pick just the first value from each of the ranges and append them as shown below.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/CONCAT-formula-Illustration-Frame-4.png” alt=”CONCAT Formula in Google Sheets” title_text=”concat-formula-google-sheets” align=”center” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Neither of these results is desirable when we are trying to combine values from multiple cells. Fortunately, we have a more elaborate formula called\u00a0<\/span>CONCATENATE<\/a>.\u00a0This accommodates multiple values and appends them in the sequence we provide them. Not just that, it also accepts the range of cells and combines the values from those cells.<\/span><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" While working with strings on spreadsheets, we may have to do many operations such as trimming, extracting, and converting. What about\u00a0joining two strings together? Sure, we can do that as well. The\u00a0CONCAT\u00a0formula in Google Sheets helps us to combine (or\u00a0concatenate) two strings into one. Syntax CONCAT(value1, value2) value1\u00a0\u2013 is the value to which the formula […]<\/p>\n","protected":false},"author":40,"featured_media":9333,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"While working with strings on spreadsheets, we may have to do many operations such as trimming, extracting, and converting. What about joining two strings together? Sure, we can do that as well. The CONCAT<\/a> formula in Google Sheets helps us to combine (or concat<\/strong>enate) two strings into one.\n\n
Usage: CONCAT formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nCONCAT(value1, value2)<\/strong>\n
\n \t
Usage: CONCAT formula in Google Sheets<\/h3>\nLet us now go ahead and look at a few examples that we tried on Google Sheets application. Please take a look at the following snapshot.\n\n
![\"CONCAT](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/CONCAT-formula-Illustration-Frame-1.png\")
\n\nAcross all the examples, we'll notice that the CONCAT formula appends the second value after the first. Regardless of whether the values are text or numeric. The functionality of this formula is the same as that of the ampersand (&) operator. We can achieve the same results using this operator. Please see the image below.\n\n![\"CONCAT](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/CONCAT-formula-Illustration-Frame-2.png\")
\n\nThere's a limitation to the CONCAT formula - in that we can only append two values together. To that effect, it won't give us the desired output if we supplied a range of values to its input parameters. It might result in an error as shown below.\n\n![\"CONCAT](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/CONCAT-formula-Illustration-Frame-3.png\")
\n\nOr surprisingly, pick just the first value from each of the ranges and append them as shown below.\n\n![\"CONCAT](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/CONCAT-formula-Illustration-Frame-4.png\")
\n\nNeither of these results is desirable when we are trying to combine values from multiple cells. Fortunately, we have a more elaborate formula called CONCATENATE<\/a>. This accommodates multiple values and appends them in the sequence we provide them. Not just that, it also accepts the range of cells and combines the values from those cells.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-9189","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/9189","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=9189"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/9189\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/9333"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=9189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=9189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=9189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}